select c.*,count(s.cat_id) from js_goods_cat as c left join js_goods_cat as s on s.parent_id = c.cat_id group by c.cat_id order by parent_id,cat_order
select c.*,count(s.cat_id) from js_goods_cat as c left join js_goods_cat as s on s.parent_id = c.cat_id group by c.cat_id order by parent_id,cat_order