如何在php中向两个有FK关系的表中插入数据

INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');

INSERT INTO orders (order_number, user_id) VALUES ('123456', LAST_INSERT_ID());

$conn = new mysqli("localhost", "username", "password", "database");
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

$sql1 = "INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')";
$conn->query($sql1);

$sql2 = "INSERT INTO orders (order_number, user_id) VALUES ('123456', LAST_INSERT_ID())";
$conn->query($sql2);

$conn->close();

$dsn = "mysql:host=localhost;dbname=database";
$username = "username";
$password = "password";

try {
    $conn = new PDO($dsn, $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql1 = "INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')";
    $conn->exec($sql1);

    $sql2 = "INSERT INTO orders (order_number, user_id) VALUES ('123456', LAST_INSERT_ID())";
    $conn->exec($sql2);

    $conn = null;
} catch(PDOException $e) {
    echo "连接失败: " . $e->getMessage();
}