title: SQL JOIN - comments with reactions (2 tables)
body: <p>I need to make one SQL command.
  From table with comments i'll get comment id, then
  with this ID I need to get count of reactions with the same comment ID and user's names.</p>
  <p>So for example I have this 2 tables:</p>
  <p>Comments:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Comm_text</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Example text</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Another example</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>and Reactions:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>comm_id</th>
  <th>usr</th>
  <th>etc..</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>1</td>
  <td>Peter</td>
  <td>another</td>
  </tr>
  <tr>
  <td>2</td>
  <td>1</td>
  <td>John</td>
  <td>collon</td>
  </tr>
  <tr>
  <td>3</td>
  <td>1</td>
  <td>Dog</td>
  <td>cuz</td>
  </tr>
  <tr>
  <td>4</td>
  <td>2</td>
  <td>Cat</td>
  <td>why not</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I need to get this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Comm_text</th>
  <th>Reactions_Count</th>
  <th>Users</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Example text</td>
  <td>3</td>
  <td>Peter, John, Dog</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Another example</td>
  <td>1</td>
  <td>Cat</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I tried this:</p>
  <pre><code>SELECT k.id, k.comm, COUNT(r.id) as reactions, r.usr
  FROM `comms` k
    INNER JOIN `reactions` r ON r.id=k.id
  </code></pre>
  <p>It's just one row with one comment and count of all rows in reaction table.</p>
  <p>Thanks.</p>