mysql如果结果为空返回0

IFNULL(字段,0)

SELECT  IFNULL(sum(soldier_unit),0)
        FROM   jz_soldier_record