GROUP_CONCAT()像这样使用：
SELECT k.id, GROUP_CONCAT(d.value)
FROM keywords AS k
INNER JOIN data as d ON k.id = d.id
GROUP BY k.id
另外，您可能需要根据需要ORDER BY d.name获取确切的值顺序。像这样：
SELECT k.id, GROUP_CONCAT(d.value ORDER BY d.name separator ' ')
FROM keywords AS k
INNER JOIN data as d ON k.id = d.id
GROUP BY k.id
602392714
清零编程群