输出MySQL结果，其中一列的数据分组为单个单元格

Question

我有一个mysql查询：

SELECT work.ID AS workID
      ,team.ID AS team_ID
      ,team.name AS teamName
  FROM work
  LEFT OUTER JOIN team_work ON team_work.work_ID = work.ID
  LEFT OUTER JOIN team ON team_work.team_ID = team.ID

返回以下样本结果：

workID   team_ID   teamName
1        10         Support
2        20         Dev
2        10         Support
3        30         Admin
4        40         Research

，我想以表格格式将其输出到屏幕上，以便每个WorkID有一个行，并且列有一个团队名称列表。类似：

WORK ID  |   TEAM NAME
-------------------------
1        |    Support
2        |    Dev
         |    Support
3        |    Admin
4        |    Research

我知道查询中的查询不是正确的方法（即使最简单）。我已经在嵌套阵列上看到了一些东西，但是作为新手，我对如何做并不清楚。

有人想花一些时间让我从壁架上说话吗？

谢谢...

Answer 1

SELECT work.ID AS workID
      ,group_concat(teamName) AS teamName
FROM work
LEFT OUTER JOIN team_work ON team_work.work_ID = work.ID
LEFT OUTER JOIN team ON team_work.team_ID = team.ID
group by work.ID