select
b1.people_name teacher_name,
b2.people_name student_name
from 表1
left join 表2 b1 on teacher_id = b1.people_id
left join 表2 b2 on student_id = b2.people_id
select
b1.people_name teacher_name,
b2.people_name student_name
from 表1
left join 表2 b1 on teacher_id = b1.people_id
left join 表2 b2 on student_id = b2.people_id