Inserting data using just added data?

Question

Yii

How to organize the initial data for the user?
For example, there is a table tags (id, user_id, tag) into which we insert data (1,1, "food"). There is a second table post(id, user_id, tag_id, text). How to get the id of the inserted tag in order to add a record to the post table, provided that many records are inserted into the table with tags at once?

Answer 1

you want to insert id tags from the tags table into the Post table?

Answer 2

1. Are you sure that there should be tags (id, user_id, tag), and not two tables:
tags (id, tag)
user_tag (user_id, tag_id)
Since users and tags are many-to-many and therefore an intermediate user_tag table is needed .
2.

How to get the id of the inserted tag in order to add a record to the post table, provided that many records are inserted into the table with tags at once?

How exactly is it inserted? Will there be a code? On idea before sending insert to a DB you have an array with the necessary data.
3. It is not clear what relationship the post table has with other tables. Describe where hasOne is, where hasMany is. There is a suspicion that your structure is, to put it mildly, strange. As far as I understand, there should be a table post(id,text,author_id), and post_tag(post_id,tag_id)