with a as( select ntID,ntParentID,ntName from tb_NewsType where ntID='9' union all select x.ntID,x.ntParentID,x.ntName from tb_NewsType x,a where x.ntParentID=a.ntID) select * from a
