一对多关系 多行转一行 外加创建临时表

WITH table1 as (                            
select t1.work_plan_id as ID,t1.operator AS USER,t1.end_time as TIME,t2.projectname as ProjectName,
            t3.deptname as DeptName, T4.flag AS FLAG,t1.operator,t4.status,t5.username as NAME  FROM (((t_workplan t1 INNER JOIN t_project t2 on t1.projectid = t2.projectid )
             INNER JOIN t_dept t3 on t2.deptid=t3.deptid)  inner JOIN  t_flow t4 on t1.work_plan_id=t4.work_plan_id) INNER JOIN t_user t5 on t4.applicant = t5.uid where t1.operator=2  ORDER BY TIME desc) 
select ID,ProjectName,TIME, DeptName,GROUP_CONCAT(NAME) AS NAME
from  table1 GROUP BY ID ,ProjectName, DeptName,TIME