SELECT
tba.leve,
dt2.*
FROM
(
SELECT
@l := @l + 1 as leve,
@id as _ids,
(SELECT @id := group_concat(id) from degree_tk where FIND_IN_SET(parent_id,@id)) as cids
FROM
(select @id :='1',@l := 0) b,degree_tk dt) tba,degree_tk dt2#单引号的值为目标id
WHERE FIND_IN_SET(dt2.id, tba._ids)
ORDER BY tba.leve, id;
无限下级查询
最新推荐文章于 2024-05-21 20:34:46 发布