SELECT *
from(
SELECT
DATE_FORMAT(CREATE_TIME,'%Y%m') mon,cost yData
FROM
hd_disp_prescribe_master
WHERE
CREATE_TIME >= '2017-01-01 00:00:00'
AND CREATE_TIME <= '2017-02-08 00:00:00'
AND PATIENT_ID ='3004075874'
group by DATE_FORMAT(CREATE_TIME,'%Y%m')
union
SELECT '2017-01' mon ,'0' yData
union
SELECT '2017-02' mon ,'0' yData
)t
GROUP BY t.mon