SELECT ec.`id`, ec.`title`, ec.`price`, ec.`lesson_num`,
ecd.`description`,
et.`name`,
es1.`title` AS oneSubject,
es2.`title` AS twoSubject
FROM edu_course ec LEFT JOIN edu_teacher et ON ec.`teacher_id`=et.`id`
LEFT JOIN edu_course_description ecd ON ec.`id`=ecd.`id`
LEFT JOIN edu_subject es1 ON ec.`subject_parent_id`=es1.`id`
LEFT JOIN edu_subject es2 ON ec.`subject_id`=es2.`id`
WHERE ec.`id`='1343828625589366785'