查询结果河南还有差率费。没有业务招待费所以不显示。我希望他可以固定显示、如果没有数据则为0即可，哪位大佬给看看

这是我的sql语句

select 

c.code as costCenterID,

ltrim(rtrim(c.name)) as costCenterName,

c.province_id as CentersupFccId,

c.province_name as  CenterSupName,

s.oaId as budgetID,

s.name as budgetName,

s.parentID  as BudgetsupId,

ltrim(rtrim((select name from budget_subject where id=s.parentID))) as BudgetsupName,

d.amount as budgetAccount,

d.date as month

from data_cache d

LEFT JOIN budget_costcenter c ON c.code=d.code

LEFT JOIN budget_subject s ON s.id=d.subject_id

WHERE code_type in(3) and c.status = 4 

${if(len(costCenterID)==0,"", "and c.code in ("+joinarray(maparray(costCenterID,"'"+item+"'"),",")+")")}

order by d.id,s.listOrder