select
t1.distributor,
COUNT(t1.distributor) as registrasi,
IF(t.transaksi is null,0,t.transaksi) as transaksi
from sma_v_aktivasi_aksestoko t1
left join
(select t2.distributor, count(t2.distributor) as transaksi from

sma_v_sales_aksestoko t2 group by t2.distributor) t
on t1.distributor = t.distributor
group by t1.dist