SQLite递归查询所有父节点

有如所示的表Organ:

我现在想查询石西城支行营业室的所有父节点及本身，即从其根节点到本身的所有节点

sql如下：

with recursive digui as 
(
    SELECT * from Organ where organId = 1788937575
    UNION ALL
    SELECT Organ.* from digui JOIN Organ ON digui.parentId = Organ.organId 
)
select * from digui ORDER BY organType ASC