SELECT e.id,title,GROUP_CONCAT(`name`) AS `name`
FROM igh_education e
LEFT JOIN igh_project p on FIND_IN_SET(project_num, e.`section`)
GROUP BY e.id
ORDER BY e.id ASC
SELECT e.id,title,GROUP_CONCAT(`name`) AS `name`
FROM igh_education e
LEFT JOIN igh_project p on FIND_IN_SET(project_num, e.`section`)
GROUP BY e.id
ORDER BY e.id ASC
转载于:https://my.oschina.net/u/2401265/blog/1589246