title: laravel DB::raw count data even if is null
body: <p>I have this query:</p>
  
  <pre><code>$providercounter = DB::table('users')
              -&gt;select(DB::raw('count(provider) as count'),'users.provider')
              -&gt;groupBy('provider')
              -&gt;orderBy('count','desc')
              -&gt;get();
      foreach($providercounter as $provider){
        $name[] = $provider-&gt;provider;
        $count[] = $provider-&gt;count;
      }
      $providerUsers = Charts::create('bar', 'highcharts')
         -&gt;title('Providers users')
         -&gt;labels($name)
         -&gt;values($count)
         -&gt;responsive(true);
  </code></pre>
  
  <p>This will retrieve my users <code>provider</code> column in chart and count them.</p>
  
  <h1>ISSUE</h1>
  
  <p>If my users are registered by their social network accounts such as <code>facebook, google etc.</code> it will get data, but <strong>if my users are registered by email address from my website (as their <code>provider</code> column is <code>null</code>) it will not retrieve and count them</strong>.</p>
  
  <h1>Question</h1>
  
  <p>How can I include my users data which their provided column is null?</p>