WITH RECURSIVE T AS ( SELECT ID, parent_sys_org_id FROM public.sys_org WHERE id = #{orgId} UNION ALL SELECT D.ID, D.parent_sys_org_id FROM public.sys_org D JOIN T ON D.parent_sys_org_id = T.ID ) SELECT t.ID FROM T ;