MySQL用于获取每月每天的日期行数

I have a table that contains a list of community events with columns for the days the event starts and ends. If the end date is 0 then the event occurs only on the start day. I have a query that returns the number of events happening on any given day:I have a table that contains a list of communit