wITH RECURSIVE r AS " +
"( select * from sys_organization where id = ?1 " +
"union all " +
"select sys_organization.* from sys_organization,r where sys_organization.parent_id = r.id ) " +
"select * from r order by id asc
查询子id 和id本身的所有数据