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
© 著作权归作者所有