MySQL查询某个子节点的顶级节点(根节点)
SELECT
T2.*
FROM
(
SELECT
@r AS _id,
( SELECT @r := parent_id FROM `look_project_process` WHERE id = _id ) AS 2v2,
@l := @l + 1 AS lvl
FROM
( SELECT @r := 'e718165baece49678359dd945371f93e', @l := 0 ) vars,
look_project_process h
) T1
LEFT JOIN look_project_process T2 ON T1._id = T2.id
WHERE
T2.parent_id IS NULL and T2.id is not null
版权声明：本文为weixin_43906569原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。