MYSQL和PHP连接2个查询

<?php
// 连接MySQL数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

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

// 执行第一个查询
$query1 = "SELECT * FROM table1";
$result1 = $conn->query($query1);

// 执行第二个查询
$query2 = "SELECT * FROM table2";
$result2 = $conn->query($query2);

// 连接查询结果
$query = "SELECT * FROM table1 JOIN table2 ON table1.id = table2.id";
$result = $conn->query($query);

// 处理连接后的结果
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        // 处理每一行数据
        echo "ID: " . $row["id"] . " Name: " . $row["name"] . "<br>";
    }
} else {
    echo "没有结果";
}

// 关闭数据库连接
$conn->close();
?>