初学SQLite，遇到一个解决不了的问题，特求教各路高手

利用mssql中的CTE可以这样来做：
;with cte as
(
   select ug.group_id, ug.group_name, ug.group_parent from user_group ug
   where ug.group_parent=
   (
      select group_id from user where user_id=2 and rownum<=1
   )
   union all
   select c.group_id, c.group_name, c.group_parent from cte c inner join user_group g
   on c.group_id=g.group_parent
)
select u.user_id, u.truename, u.name
from user u,(select * from cte) as t
where t.group_id=u.group_id and u.state<>3