经典sql语句

select b.*,(select count(a.id) from td_product a where a.protypeid=b.id) num from td_protype b