帝国CMS拼音目录去重复值id

$sql=$empire->query("select id,filename from phome_ecms_cidian where classid=1 group by filename having(count(*))>1"); //词典表栏目1的数据去重
while($r=$empire->fetch($sql)){
echo $r[id].':'.$r[filename].PHP_EOL;
if($r[id]){
$py=$r[id].'/index';
$url='https://www.zggushi.com/ci/'.$r[id].'/';
$empire->query("update phome_ecms_cidian set filename='{$py}',titleurl='{$url}' where id=$r[id] limit 1");
}
}