sqlite 递归查询

with recursive digui as
(
SELECT * from COMPANY where _id = 1
UNION ALL
SELECT COMPANY.* from digui JOIN COMPANY ON COMPANY.parent_Id = digui._id
)
select * from digui

该语句意为查询属于id为1的公司下面的所有子公司