title: How to JOIN three tables with IN array filter, but still get all the rows from third table
body: <p>I have Users and Skills table connected through UserSkills table for many-to-many relation. Here is what's in the tables:</p>
  
  <pre><code>Users (id, username)
  Skills (id, name)
  UserSkills (user_id, skill_id)
  </code></pre>
  
  <p>I have an array of skills that I am looking for ['C#', 'SQL']. So I am doing join with IN filtering operation to get only those users that I need.</p>
  
  <pre><code>SELECT (username, GROUP_CONCAT(Skills.name)) FROM Users
  JOIN UserSkills ON Users.id = UserSkills.user_id
  JOIN Skills ON Skills.id = UserSkills.skill_id AND Skills.name IN ('C#', 'SQL')
  GROUP BY Users.id
  </code></pre>
  
  <p>I want to get same users list but with all their skills, not only those that I am looking for. For instance:</p>
  
  <pre><code>In my case I get: username: 'joe' | skills: 'C#', 'SQL'
  I want to get: username: 'joe' | skills : 'C#', 'SQL', 'JavaScript', 'NodeJS'
  </code></pre>
  
  <p>Please help.</p>