如何在php中删除一个mysql查询中两个表的数据？

$sql = "DELETE t1, t2 FROM table1 t1 JOIN table2 t2 ON t1.common_field = t2.common_field WHERE <条件>";

// 创建数据库连接
$conn = new mysqli("数据库主机", "用户名", "密码", "数据库名");

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 构建SQL查询语句
$sql = "DELETE t1, t2 FROM table1 t1 JOIN table2 t2 ON t1.common_field = t2.common_field WHERE <条件>";

// 执行SQL查询
if ($conn->query($sql) === TRUE) {
    echo "删除成功";
} else {
    echo "删除失败: " . $conn->error;
}

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