select gmt_Id_i ,gmt_Name_v, (select count(*) from tb_mgoods where goods_MoreType_v=tb_mgoodsmoretype.gmt_Id_i) as counts from tb_mgoodsmoretype where gmt_Id_i in(10,121)
