mysql自上而下查询所有子集

  with recursive tb (id) as
        (
        select F_ID
        from base_organize
        where F_ParentId IN(#{joinedString})

        union all

        select c.F_Id
        from base_organize c
        join tb t
        on c.F_ParentId = t.id
        )
        select *
        from tb;