1:select * from exam_proclass
2: SELECT d.frist_id,d.frist_name,d.second_id,d.second_name,c.id as third_code,c.`name` as third_name from exam_proclass c join (SELECT a.id as frist_id,a.`name` as frist_name,b.id as second_id,b.`name` as second_name from exam_proclass a join exam_proclass b on a.id = b.fatherid ) d on c.fatherid = d.second_id