mysql 父级统计本级以及子级总数，子级统计本身的数量

Question

滨海新区分行是天津塘沽支行的父级,ORGDGREE用来区分 支行还是分行，subbank_2 标识分行，brank标识支行。ORGID2是父级id，支行的为父级id，分行的为本身。需要查出滨海新区分行的 COUNT1 =6 ,COUNT2=0,COUNT3=2,COUNT4=0.其他的数据保持不变

Answer 1

select 
a.orgcode,
a.orgname,
a.orgdgree,
a.orgid,
a.orgid2,
sum(b.count1) count1,
sum(b.count2) count2,
sum(b.count3) count3,
sum(b.count4) count4
from 
table a,
table b
where a.orgid = b.orgid2