title: How to get all the data starting current week of monday to saturday only using mysql
body: <p>I have question regarding on mysql, How to get all the data of the current week starting Monday to Saturday. let's say the date today is October 5, 2020 (Monday) the only data I want to get is from starting October 5, 2020 until October 10, 2020</p>
  <p><strong>Goal: To get the data starting monday to saturday only of the current week.</strong></p>
  <p>I have here my sample script that I already created.</p>
  <pre><code>$flavors_breakdown_summary_report = DB::select('
  SELECT item
       , item_category
       , unit
       , SUM(item_qty) as flavors_item_qty
       , op.receipt_code
       , created_at
       , is_payment_submit 
    FROM order_process as op
    LEFT 
    JOIN
      ( SELECT receipt_code
   , status
   , is_payment_submit 
    FROM order_process_reference) opr 
      ON op.receipt_code = opr.receipt_code
      WHERE op.item_category = ? 
     AND yearweek(DATE(op.created_at), 1) = yearweek(curdate(), 1) 
     AND is_payment_submit = ? 
     AND opr.status = ?  
   GROUP 
      BY item 
   ORDER 
      BY item ASC
  ',['Flavored','1','Stock']);
  </code></pre>
  <p>Output:</p>
  <p><a href="https://i.stack.imgur.com/bipri.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bipri.png" alt="Output" /></a></p>
  <p>As you can see the order date created is september 28, 2020 - The date today in our country is October 4, 2020. which mean this script is wrong.</p>