表结构:
id ParentId Name
WITH temps
AS
(
SELECT * FROM tb WHERE ID = 152
UNION ALL
SELECT m.* FROM tb AS m
INNER JOIN temps AS child ON m.ParentId = child.Id
)
SELECT * FROM temps
表结构:
id ParentId Name
WITH temps
AS
(
SELECT * FROM tb WHERE ID = 152
UNION ALL
SELECT m.* FROM tb AS m
INNER JOIN temps AS child ON m.ParentId = child.Id
)
SELECT * FROM temps