mysql 查询某一月每天得数据显示当月得每天及对应得数据

`select
a.d time,
b.max maxTemperature,
b.min minTemperature,
b.temperatureDiff,
b.maxIn,
b.minIn,
b.inDiff,
b.maxOut,
b.minOut,
b.outDiff,
b.maxDiv,
b.minDiv,
b.divDiff,
b.deviceId
from
(SELECT ADDDATE(y.first, x.d - 1) as d
FROM
(SELECT 1 AS d UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL
SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10 UNION ALL SELECT 11 UNION ALL SELECT 12 UNION ALL SELECT 13 UNION ALL SELECT 14 UNION ALL
SELECT 15 UNION ALL SELECT 16 UNION ALL SELECT 17 UNION ALL SELECT 18 UNION ALL SELECT 19 UNION ALL SELECT 20 UNION ALL SELECT 21 UNION ALL
SELECT 22 UNION ALL SELECT 23 UNION ALL SELECT 24 UNION ALL SELECT 25 UNION ALL SELECT 26 UNION ALL SELECT 27 UNION ALL SELECT 28 UNION ALL
SELECT 29 UNION ALL SELECT 30 UNION ALL SELECT 31) x,
(SELECT CONCAT(‘2023-01’,‘-01’) as FIRST, DAY(LAST_DAY(str_to_date(‘2023-01’,‘%Y-%m’))) AS last) y
WHERE x.d <= y.last ) a
left join
(
select
MAX(temperature) max,
MIN(temperature) min,
MAX(temperature)- MIN(temperature) as temperatureDiff,
MAX(inlet_pressure) maxIn,
MIN(inlet_pressure) minIn,
MAX(inlet_pressure)- MIN(inlet_pressure) as inDiff,
MAX(outlet_pressure) maxOut,
MIN(outlet_pressure) minOut,
MAX(outlet_pressure)- MIN(outlet_pressure) as outDiff,
MAX(divulget_density) maxDiv,
MIN(divulget_density) minDiv,
MAX(divulget_density)- MIN(divulget_density) as divDiff,
device_id deviceId,
DATE_FORMAT(created_at,“%Y-%m-%d”) time
from pressure_statistics where
deleted_at=0 and DATE_FORMAT(created_at,“%Y-%m”)=“2023-01” and device_id=1601386507330363393
GROUP BY time ) b
on a.d=b.time