title: Laravel 5.4 - group by, count and join
body: <p>I have two tables (models have the same name as the tables):</p>
  
  <pre><code>StatusNames: id|name
  </code></pre>
  
  <p>and </p>
  
  <pre><code>CurrentUserStatus: id|user_id|status_id
  </code></pre>
  
  <p>At the moment <strong>CurrentUserStatus</strong> is empty, and <strong>StatusNames</strong> have several records inserted (Active, Inactive, On Pause, Terminated...).</p>
  
  <p>I need to get all data from <strong>CurrentUserStatus</strong> and show how much are there within each status (given the current tables, next to each status name there should be zero (0)).</p>
  
  <p>Is this possible to do with one query?</p>