MySQL GROUP BY日期 - 如何在没有行时返回结果

I am writing a query to return the number of blog posts written per day over a certain period of time. My problem arises when there are no records of a blog for a given day. With my query, the result for that day is simply skipped altogether. I am writing a query to return the number of bl