第一：select s.type_id,s.type_name,p.type_name from tdb_goods_types as s left join tdb_goods_types as p
on s.parent_id=p.type_id
第二：select p.type_id,p.type_name,count(s.type_name) from tdb_goods_types as p left join tdb_goods_types as s
on s.parent_id=p.type_id group by p.type_name order by p.type_id
