MySQL vertical table to horizontal table need join cannot direct where connection

Select t.student_id, T4.name, T5.name, Ifnull (T6.name, "")
From Student_info t
Left join Student_type t1 in t.student_id=t1.student_id and T1.level=0 left joins student_type_info T4 on T1.type_id=t4.id
Left join Student_type T2 in t.student_id=t2.student_id and T2.level=1 left joins Student_type_info T5 on T2.type_id=t5.id
Left join Student_type T3 in t.student_id=t3.student_id and t3.level=2 left joins Student_type_info T6 on T3.type_id=t6.id
Order BY t.student_id;

MySQL vertical table to horizontal table need join cannot direct where connection