title: Inserting new values combined with a select query using prepared statements
body: <p>What is the correct syntax for inserting new values combined with a select query using prepared statements?</p>
  
  <p>What I have doesn't work.</p>
  
  <pre><code>INSERT INTO productsUsers
      (product, userId)
  VALUES
      (?, SELECT id FROM users WHERE username = ?)
  </code></pre>