title: Get set of ID's from one table and use them to spawn a row in different table
body: <p>I have 2 tables 'users' and 'settings'. I am trying to create a new row in settings for each user in users to initialize a default setting.</p>
  
  <pre><code>INSERT INTO settings
      (user_id, setting_id, value)
  VALUES 
      (
          (SELECT id
          FROM users),
          16,
          true
      )
  </code></pre>
  
  <p>this returns the error</p>
  
  <blockquote>
    <p>ERROR: more than one row returned by a subquery used as an expression
    SQL state: 21000</p>
  </blockquote>