postgres 递归查询子数据

单独使用

WITH RECURSIVE r AS (
SELECT * FROM product_category pc1 where pc1.id = 1
union  ALL
SELECT pc2.* FROM product_category pc2, r WHERE pc2.parent_id = r.id)
SELECT id FROM r ORDER BY id;

Sql中嵌套使用

AND pt.categ_id in (WITH RECURSIVE r AS (
    SELECT * FROM product_category pc1 where pc1.id = sgsl.product_category_id
    union  ALL
    SELECT pc2.* FROM product_category pc2, r WHERE pc2.parent_id = r.id)
    SELECT id FROM r ORDER BY id)