title: Foreach id in one table, insert row in another table
body: <p>I have two tables. Table 'locations' is One-To-Many/One related with table 'resources' with foreign key location_id. Something like this</p>
  
  <pre><code>locations -&gt; id | location
  resources -&gt; id | location_id | name | value
  </code></pre>
  
  <p>I have a lot of records in 'locations'. Now i want to add for each existing 'locations.id' in 'locations', a record in 'resources' with default values for name and value and the location_id of course.</p>
  
  <p>I tried query below which generates partially the desired result, because this sql query dosent set values for 'resoruces.name' and 'resources.value'. They should be respectively "standard" and "1".</p>
  
  <pre><code>INSERT INTO service_categories(location_id) SELECT id FROM locations;
  </code></pre>
  
  <p>I just cant construct the query with adding values for this fields. How to do this?
  The result which i want is something like this:</p>
  
  <pre><code>    id | location_id | name     | value
  -------------------------------------
      1  | 1           | Standard | 1
      2  | 2           | Standard | 1
      3  | 3           | Standard | 1
      4  | 4           | Standard | 1
      5  | 5           | Standard | 1
      6  | 6           | Standard | 1
      7  | 7           | Standard | 1
      8  | 8           | Standard | 1
  ....
  </code></pre>