一、舉例

selectt1.*,t2.name as student_name,t3.name as teacher_name
FROMclass_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.