SELECT g.group_name,GROUP_CONCAT(i.savepath SEPARATOR ',')AS path,GROUP_CONCAT(i.savename SEPARATOR ',') AS savename FROM img AS i JOIN `group` AS g ON i.company_id=g.company_id WHERE i.id in(select img_id FROM `group`) GROUP BY g.id 最佳答案
SELECT g.group_name,GROUP_CONCAT(i.savepath SEPARATOR ',')AS path,GROUP_CONCAT(i.savename SEPARATOR ',') AS savename FROM img AS i JOIN `group` AS g ON i.company_id=g.company_id WHERE i.id in(select img_id FROM `group`) GROUP BY g.id