连表查询统计某一板块下的子板块数目

select a.ID,a.name,a.imgUrl,(select count(ID) from share where a.ID=plateID) from plate a;