SELECT classes.id, classes.name AS classname, teachers.name, teachers.lastname, students.name, students.lastname FROM teachers JOIN classes ON teachers.id = classes.id_teacher JOIN students ON classes.name = students.class;
