mysql向上递归，字符串拼接

WITH RECURSIVE cte   AS (
   SELECT ID, GROUP_NAME, PARENT_ID ,0 AS level
     FROM your_table_name
     WHERE id =#{id}
--         WHERE parent_id IS NULL
   UNION ALL
   SELECT c.id, c.GROUP_NAME, c.parent_id ,ch.level + 1
     FROM
     your_table_name c
     INNER JOIN
     cte ch
     ON
        ch.parent_id= c.id  
    
)
SELECT GROUP_CONCAT( GROUP_NAME ORDER BY level DESC SEPARATOR '/' ) as path  FROM cte

your_table_name=>表名

ch.level + 1=》需要 0 AS level为临时字段

如此才能执行获取向上递归的顺序