MySQL根据一张表中的两个字段引用另外一张表中的同一个字段进行查询

---

一、举例

select
   t1.*,
   t2.name as student_name,
   t3.name as teacher_name
FROM
   class_info AS t1
INNER JOIN user_table AS t2 ON t1.student_id = t2.id
INNER JOIN user_table AS t3 ON t1.teacher_id = t3.id

其中user_table 表中的student_name和teacher_name对应的是class_info 表中的name.