根据id使用sql递归查询层级结构和使用sql递归查询层级结构后删除下面的层级结构

递归查询层级结构

WITH RECURSIVE cte AS (
  SELECT *
  FROM your_table
  WHERE id = '1688357681144'
  UNION ALL
  SELECT t.*
  FROM your_table t
  INNER JOIN cte ON t.parent_uuid = cte.id
)
SELECT * FROM cte;

递归查询层级结构后删除

WITH RECURSIVE cte AS (
  SELECT *
  FROM your_table
  WHERE parent_uuid = '1688357681144'
  UNION ALL
  SELECT t.*
  FROM your_table t
  INNER JOIN cte ON t.parent_uuid = cte.id
)
DELETE FROM your_table WHERE id IN (SELECT id FROM cte);