Используй JOIN.
Типо так, не тестировал..
SELECT get_book.id AS id, get_book.date AS date, student.id AS studentId, student.name AS name, student.surname AS surname FROM get_book INNER JOIN student ON get_book.id_student = student.id WHERE get_book.stat = 1;