SELECT
IFNULL(sum( a.stay_money ) ,0.00) stayMoney,
IFNULL(sum( a.already_money ) ,0.00) alreadyMoney,
IFNULL(sum( a.err_money ) ,0.00) errMoney,
UNIX_TIMESTAMP( CAST( SYSDATE( ) AS DATE ) ),
UNIX_TIMESTAMP('2019-09-27 23:59:59')
FROM
statistics_up_or_me_hour_up a
WHERE
a.mid = 1
AND a.statistics_time >= UNIX_TIMESTAMP( CAST( SYSDATE( ) AS DATE ) )
AND a.statistics_time <= UNIX_TIMESTAMP( CAST( SYSDATE( ) AS DATE ) ) + 86400 - 1