title: how to select all week monday to sunday in mysql?
body: <p>I try to select dates to my query but I also want to get for example sunday even no sunday on the date of my sql. it gets sunday as zero. </p>
  
  <p>here is mysql</p>
  
  <pre><code>SELECT
      DATE(log_date) DATE,
      COUNT(users) active_users,
      DATE_FORMAT(log_date,'%a') DAYNAME
  FROM tbl_accounts
  WHERE
      DATE(log_date) BETWEEN DATE(:now) - INTERVAL 1 WEEK AND DATE(:now)
  GROUP BY DATE(log_date);
  </code></pre>
  
  <p>What I what to happen is select monday to sunday even there is no sunday I still want to select moday and it will show zero value if empty? is it possible?</p>
  
  <p>Sample Output: 
  <a href="https://i.stack.imgur.com/z5FDQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z5FDQ.png" alt="enter image description here"></a></p>
  
  <p>I want this output to become monday-sunday and then sunday will show zero if there is no sunday.</p>