WITH RECURSIVE r AS (SELECT * FROM [表] WHERE id = xxxunion ALLSELECT [表].* FROM [表], r WHERE [表].id = r.parent_id)SELECT * FROM r ORDER BY id;
递归向上查询数据
postgre sql递归查询
原文：https://www.cnblogs.com/snail90/p/9972447.html
