postgreSql的树节点查询所有子节点

WITH RECURSIVE r AS ( SELECT * FROM system_module WHERE module_id = 0 union ALL SELECT system_module.* FROM system_module, r WHERE system_module.parent_module_id = r.module_id) SELECT * FROM r ORDER BY module_id;