请帮我用PHP连接数据库执行以下SQL语句：SELECT vod_id type_id vod_name vod_year FROM mac_vod WHERE vod_name vod_year IN SELECT vod_name vod_year FROM mac_vod GROUP BY vod_name vod_year HAVING COUNT 1 ORDER BY vod_nam

以下是使用PHP连接数据库并执行给定的SQL语句，将结果存储在数组中的示例代码：

<?php
// 数据库连接信息
$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);
}

// 执行SQL查询语句
$sql = "SELECT vod_id, type_id, vod_name, vod_year FROM mac_vod WHERE (vod_name, vod_year) IN( SELECT vod_name, vod_year FROM mac_vod GROUP BY vod_name, vod_year HAVING COUNT(*) > 1 ) ORDER BY vod_name ASC";
$result = $conn->query($sql);

// 存储结果的数组
$data = array();

if ($result->num_rows > 0) {
    // 循环遍历查询结果
    while($row = $result->fetch_assoc()) {
        $vod_id = $row["vod_id"];
        $vod_name = $row["vod_name"];
        $vod_year = $row["vod_year"];

        // 判断是否已经存在相同的vod_name，如果存在则将vod_id添加到对应的数组中
        $found = false;
        foreach ($data as &$item) {
            if ($item["id"] == $vod_name) {
                $item["id_1"][] = $vod_id;
                $found = true;
                break;
            }
        }

        // 如果不存在相同的vod_name，则创建一个新的组
        if (!$found) {
            $data[] = array("id" => $vod_id, "id_1" => array($vod_id));
        }
    }
}

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

// 输出结果
print_r($data);
?>

请根据实际情况修改$servername，$username，$password，$dbname变量的值来连接到您的数据库