IFNULL(字段,0)

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