【无标题】

mysql单位树查询 记录下
可能需要开启

with RECURSIVE tree as
(
SELECT DATA.dwbh,DATA.dwmc FROM(
SELECT
@ids AS _ids,
(
SELECT @ids := GROUP_CONCAT(dwbh)
FROM prd_dw
WHERE FIND_IN_SET(PARENTID, @ids)
) AS cids,
@l := @l+1 AS level
FROM prd_dw, (SELECT @ids := ‘01’ , @l := 0 ) b
WHERE @ids IS NOT NULL
) ID, prd_dw DATA
WHERE FIND_IN_SET(DATA.dwbh, ID._ids)

order by dwbh

#ORDER BY level
)

select * from tree