获取sql Id并立即将其插入另一个查询

I have two tables first called messages and the other called messages_reply.

I used this code to insert into messages table:

$query = "INSERT INTO `messages` VALUES('', '$id', '$otherId', '')";
$query_run = mysqli_query($connect, $query);

I have the first column auto_increment thats why I left it empty by writing ''

Now i want this auto_increment value that i have inserted to be inserted in the other table called messages_reply

Do I have to create another query to return it or there is an instant way to insert it here and there?

you have to select the last id on table messages first, then you can insert that last id + 1 into messages reply

$query_sel_last_id = "SELECT id FROM messages ORDER BY id desc LIMIT 1"; // select the last id

after that, you only need to insert to messages_reply, remember to plus the value

$query_sel_last_id + 1

EDIT: gordon's solution is better and simpler, LAST_INSERT_ID()