PostgreSQL递归查询

首先看一下表结构：

CREATE TABLE ide_iedp_project
(
  project_id integer NOT NULL ,
  project_code character varying(50),
  project_name character varying(255),
  access_token character varying(255),
  parent_project_id integer,
  CONSTRAINT ide_iedp_project_pkey PRIMARY KEY (project_id)
)

然后看一下表中数据：

再说一下取数逻辑：
根据传入的project_id，获取等于该project_id 及parent_project_id等于该值，以及递归下去的值。
最后，上代码：

WITH RECURSIVE project AS ( 
     SELECT * FROM ide_iedp_project WHERE project_id = #{projectId} 
     union  all 
     SELECT ide_iedp_project.* FROM ide_iedp_project, project WHERE ide_iedp_project.parent_project_id = project.project_id 
            ) 
    SELECT project_id, project_name FROM project ORDER BY project_id