SELECT o.out_trade_no,o.price,s.c_name as subject_name,m.nickname,FROM_UNIXTIME(o.pay_time, '%Y-%m-%d %H:%i:%s')as pay_time
FROM `hy_order` AS o
LEFT JOIN `hy_course_subjects` as s ON o.subject_id = s.c_id
LEFT JOIN `hy_member` as m ON o.member_id = m.id
WHERE o.is_pay = 1 AND o.subject_id > 12