title: Insert into with select (prepared statement)
body: <p><strong>I want this query:</strong></p>
  
  <pre><code>INSERT INTO
      users_groups (user_id, group_id)
  VALUES
      (?, (SELECT group_id FROM groups WHERE group_name = ?))
  </code></pre>
  
  <p><strong>tables:</strong></p>
  
  <pre><code>users_groups:
  | user_id | group_id |
  
  groups
  | group_id | group_name |
  </code></pre>
  
  <p>How can I get this working?</p>