;with cte as
(
select orgid,parentorgid from org_organization
where orgid = 1
union all
select org_organization.,org_organization.parentorgid from cte
join org_organization org_organization
on cte.orgid = org_organization.parentorgid
)
select * from cte
大神帮我看看我这个mysql递归报[SQL];
[Err] 1065 - Query was empty这个错，是不是mysql就不支持这种方法，求助攻
