select DISTINCT pdu.userNum as username,c.daikou_debit as daikouDebit,c.*,u.realname,d.departname as belongUnitName, du.duties_name as duname,pdu.idcard as pduname,fin.belong_bank,fin.card_number as cardNumber 
	
	from t_bus_user_wage c left join t_s_base_user u on c.userid = u.id 
	
	left join t_bus_user_personnel per on per.userid = u.id 
	
	left join t_s_depart d on d.id = c.pjt_id
	
	left join t_bus_duties du on du.id = per.belong_dutiesid
	
	left join t_s_user pdu on pdu.id = u.id
	
	left join t_bus_user_financial fin on fin.userid = u.id and isdefault = '1' and fin.delete_flag='0'
	where 1=1 and u.delete_flag='0'
 and u.id=:userId
 and c.monthly between :startMonth and :endMonth