如果某个记录不可用，那么我需要在MYSQL查询中显示为0

SELECT DATE(login) AS loginDate, COALESCE(COUNT(login),0) AS loginCount    
  FROM LMS_LoginTracking 
 WHERE prism_mem_id = 55308
   AND DATE(login) BETWEEN '2017-01-04T18:30:00.000Z' AND '2017-01-09T18:30:00.000Z'
 GROUP BY DATE(login)
SELECT DATE(login) AS loginDate, COALESCE(COUNT