title: Combine INSERT INTO and SELECT on MySQL
body: <p>Step 1) Find the <em>id</em>s in <em>users</em> table that does not exist in players table.
  Step 2) Insert into players table with those missing <em>id</em>s</p>
  
  <p>So I should combine these two queries. (Giving the result of the SELECT query as a list to the INSERT INTO query)</p>
  
  <pre><code>SELECT users.uid 
  FROM users 
  WHERE users.uid NOT IN (select uid from players);
  
  INSERT INTO players (uid)
  VALUES ()
  </code></pre>
  
  <p>What is the cleanest way to do this?</p>