pg数据库自顶向下递归查询组织列表

WITH RECURSIVE org AS 
( SELECT * FROM t_sys_org WHERE parent_id = - 1
 UNION ALL SELECT t_sys_org.* FROM t_sys_org, org WHERE t_sys_org.parent_id = org.org_id ) 
SELECT
* 
FROM
	org 
WHERE
	org.dem_code = 1 
ORDER BY
	parent_id