SELECT S.*,T.name,T.gender,T.gender_sequence,T.photo,T.qualifications,T.teacher_code,C.style_name,SUBJ.subject_name
FROM t_sample_table AS S
LEFT JOIN t_teacher_table AS T ON S.teacher_id=T.id
LEFT JOIN t_teacher_language_table AS L ON T.id=L.teacher_id
LEFT JOIN t_category_subject_table AS SUBJ ON S.subject_parent_id=SUBJ.id
LEFT JOIN t_category_style_table AS C ON S.style_id=C.id WHERE 1=1 AND L.ad_price <= 0 AND T.status = 1
