How can I add data to multiple tables with a single insert into?

Question

MySQL

A piece of code that adds a record to one table, but how to add it to two at once?

// Insert new record into the contacts table
    $stmt = $pdo->prepare('INSERT INTO `Client`(`id`, `surname`, `name`, `patron`, `serie`, `number`, `propiska`,`telephone`)  VALUES (?,?,?,?,?,?,?,?)');/*ошибка ,удалить `банк`*/
    $stmt->execute([$id, $surname, $name, $patron, $serie, $number, $propiska,$telephone,/*$ls,$balance,$date*/]);/*error*/

Answer 1

$stmt = $pdo->prepare('INSERT INTO `Client`(`id`, `surname`, `name`, `patron`, `serie`, `number`, `propiska`,`telephone`)  VALUES (?,?,?,?,?,?,?,?)');/*ошибка ,удалить `банк`*/
    $stmt->execute([$id, $surname, $name, $patron, $serie, $number, $propiska,$telephone,/*$ls,$balance,$date*/]);/*error*/
    $stmt = $pdo->prepare('INSERT INTO `Client2`(`id`, `surname`, `name`, `patron`, `serie`, `number`, `propiska`,`telephone`)  VALUES (?,?,?,?,?,?,?,?)');/*ошибка ,удалить `банк`*/
    $stmt->execute([$id, $surname, $name, $patron, $serie, $number, $propiska,$telephone,/*$ls,$balance,$date*/]);/*error*/

Answer 2

MySQL does not support multi-table INSERT.
Options:

1. Stored procedure
   
2. Trigger (but you need to solve the problem with passing parameters for other tables)