sql with 递归查询（单表多级查询）

 

with unionTable as

(

   SELECT * FROM FmAccountItems WHERE ItemId = '100'

   union all

   select subTable.* from FmAccountItems subTable join unionTable parentTable on subTable.ParentItemId=parentTable.ItemId

)

select * from unionTable