SELECT S.*, SUBJ.subject_name, ST.style_name
FROM t_sample_table S
LEFT JOIN t_category_subject_table SUBJ ON S.subject_parent_id = SUBJ.id
LEFT JOIN t_category_style_table ST ON S.style_id = ST.id WHERE teacher_id = '10047' AND language_second_id = '8'
