MySQL Group by – Get columns with zero count [on hold]

table:

STATUS

Accept

query

select status,count(*) as count from expense group by status;

result:

status| count

accept 1

i want this format please help me

status| count

accept 1 reject 0 pending 0