title: MySql Raw Query into Laravel 5.5 Eloquent ORM
body: <p>I have mySql query an I want to convert it into Laravel 5.5 Eloquent ORM.</p>
  
  <p>mySql Query:</p>
  
  <pre><code>SELECT i.category_id, count(i.id) as count FROM `items` i INNER JOIN item_categories c ON c.id = i.`category_id` GROUP BY i.`category_id`
  </code></pre>
  
  <p>This query is working. Is there any way to convert it easily into eloquent or anyone can make it for me.</p>