SELECT CI_ID,GROUP_CONCAT(STU_NAME) AS STU_NAME FROM
(SELECT p.CI_ID,s.STU_NAME
FROM pm_ci p , pm_stu s
WHERE FIND_IN_SET(s.STU_ID,p.STU_IDS)) AS n
GROUP BY CI_ID;
/*mysql版本*/
select e.id,wm_concat(e.name)
from(select c.ci_id id,s.stu_name name
from pm_ci c,pm_stu s
where instr(c.stu_ids,s.stu_id)>0
order by 1,2) e
group by e.id
