title: How to get individual count of same value rows with join
body: <p>I just want to know how to get individual count of same value rows with join using mysql and help are definitely appreciated </p>
  
  <p>Here is my mysql Query </p>
  
  <pre><code>SELECT c.`id` 
    FROM categories c inner join subcategories sc 
             on c.`id` = sc.`cat_id`
  </code></pre>
  
  <p>See the Response screeshot</p>
  
  <p><img src="https://i.stack.imgur.com/ZOX4m.png" alt="enter image description here"></p>