mysql连续日期无数据_MySQL中实现连续日期内数据统计,缺省天数0补全

某一日，需要查询订单表中一个月每天的金额数

查询出数据如下:

array(14) {

[0] => array(2) {

["money"] => string(7) "2000.00"

["times"] => string(2) "12"

}

[1] => array(2) {

["money"] => string(7) "6000.00"

["times"] => string(2) "14"

}

[2] => array(2) {

["money"] => string(8) "31569.00"

["times"] => string(2) "15"

}

[3] => array(2) {

["money"] => string(9) "134596.50"

["times"] => string(2) "16"

}

[4] => array(2) {

["money"] => string(7) "4000.00"

["times"] => string(2) "17"

}

[5] => array(2) {

["money"] => string(8) "20525.00"

["times"] => string(2) "18"

}

[6] => array(2) {

["money"] => string(7) "2000.00"

["times"] => string(2) "20"

}

[7] => array(2) {

["money"] => string(7) "6000.00"

["times"] => string(2) "21"

}

[8] => array(2) {

["money"] => string(7) "9000.00"

["times"] =>