mysql - PHP - SQL how to select ids from table and insert into another table? -

i need inner join insert statement. need insert data 2 tables id of records second table should stored column first table.

the first sql section makes new record every given dj name in dj table, second part supposed id added dj , insert column table "articles".

$alle_djs = explode(', ', $this->djs); foreach ($alle_djs $elke_dj) {   $sql = "insert dj (name) values ( :name_dj )";   $st = $conn->prepare($sql);   $st->bindvalue( ":name_dj", $elke_dj, pdo::param_str );   $st->execute();    $sql2 = "insert articles (dj_ids) select id dj name=:name_dj";   $st2 = $conn->prepare($sql2);   $st2->bindvalue( ":name_dj", $elke_dj, pdo::param_str );   $st2->execute(); } $conn = null 

use last_insert_id() function:

$sql2 = "insert articles(dj_ids) values (last_insert_id())";