SELECT L.*,T.name,T.gender,T.gender_sequence,T.photo,T.qualifications,T.intro,T.teacher_code,T.sort_order,T.stars,T.self_intro_url,T.age_range,G.language_name
FROM t_teacher_language_table AS L
LEFT JOIN t_teacher_table AS T ON L.teacher_id=T.id
LEFT JOIN t_category_language_table as G ON G.id= L.language_id WHERE T.status = 1 AND T.gender = 1 AND T.age_range = 2
