写一个原始mysql语句和thinkphp格式的查询语句要求如下查询z_data_hours表中measure_id字段in数组1234时以时间字段datetime中的小时和分钟为分组依据查询当前小时和分钟时间内Leq_Data的平均值和datetime的小时和分钟格式

原始MySQL语句：

SELECT 
    DATE_FORMAT(datetime, '%H:%i') AS time,
    AVG(Leq_Data) AS average
FROM 
    z_data_hours
WHERE 
    measure_id IN (1, 2, 3, 4)
GROUP BY 
    DATE_FORMAT(datetime, '%H:%i')

ThinkPHP格式的查询语句：

$measureIds = [1, 2, 3, 4];
$result = Db::table('z_data_hours')
            ->field("DATE_FORMAT(datetime, '%H:%i') AS time, AVG(Leq_Data) AS average")
            ->where('measure_id', 'in', $measureIds)
            ->group("DATE_FORMAT(datetime, '%H:%i')")
            ->select();
``