湘西凤凰

Select FengGuangID,FengGuangName,SmallPicurl,BigPicUrl From FengGuang Where ClassID=44 Or ClassID In (Select ClassID From Class Where ParentID=44) Order By OrderID