SQL 递归

向上
WITH RECURSIVE r AS (
SELECT * FROM acu_customercircle 
WHERE circleunitid = 'd05c24fa-dc32-4357-8a48-0f72efdfd85a'  union ALL SELECT 

acu_customercircle.* FROM acu_customercircle,
r WHERE acu_customercircle.circleunitid = r.guidparentid)
SELECT * FROM r ORDER BY circleunitid;

向下
WITH RECURSIVE T (circleunitid, strname, guidparentid, dwgrade)  AS (
    SELECT circleunitid, strname, guidparentid, dwgrade
    FROM acu_customercircle
    WHERE circleunitid = '712a9d32-e7d9-41d7-b07f-42a2e8c4a827'
    UNION ALL
    SELECT  D.circleunitid, D.strname, D.guidparentid, D.dwgrade
    FROM acu_customercircle D
    JOIN T ON D.guidparentid = T.circleunitid)
    SELECT circleunitid, strname, guidparentid, dwgrade FROM T
ORDER BY dwgrade;