ddd

 select temp.date CATEGORIES,
        IFNULL(hy.num,0) Value from
        (SELECT
        DATE_FORMAT(
        ADDDATE(
        '2020-08-11',
        INTERVAL @d DAY
        ),
        '%Y-%m-%d'
        ) AS date ,@d :=@d + 1 day
        FROM
        sys_town,
        (SELECT @d := 0) temp
        WHERE
        ADDDATE(
        '2020-08-11',
        INTERVAL @d DAY
        ) <= DATE_FORMAT('2020-11-11','%Y-%m-%d')
        ORDER BY day
        ) temp LEFT JOIN (SELECT DATE_FORMAT(ADD_TIME,'%Y-%m-%d') as hydate, count(*) num
        FROM HY_MEMBER_INFO
        where ISTATUS = 1
        AND IDEL_FLAG =0
       
        group by DATE_FORMAT(ADD_TIME,'%Y-%m-%d')
        ) hy
        on hy.hydate = temp.date
        ORDER BY temp.day