首次查询之后的结果:
SELECT
c.id,
GROUP_CONCAT(c1.id) AS childIds
FROM category c
LEFT JOIN category c1
ON c.id = c1.parentId
WHERE c.parentId = 1 GROUP BY c.id;
列childIds的顺序是乱的,并不是我想要的,修改之后的sql:
SELECT
c.id,
GROUP_CONCAT(c1.id ORDER BY c1.sort ASC) AS childIds
FROM category c
LEFT JOIN category c1
ON c.id = c1.parentId
WHERE c.parentId = 1 GROUP BY c.id;