title: Select distinct value count laravel
body: <p>I have an orders table where there is a status column.</p>
  
  <p>I am trying to get the count of each status like this :</p>
  
  <pre><code>$pending = Order::where('status','=','pending')-&gt;count();
  $active = Order::where('status','=','active')-&gt;count();
  </code></pre>
  
  <p>But this is not efficient as  am having to make one call for each status type.</p>
  
  <p>How can I reduce number of queries ?</p>