Tablo adı test, onu düzenleyin

$query = $db->query("SELECT modelKodu FROM test GROUP BY modelKodu")->fetchAll(2);

foreach ($query as $item) {
$q = $db->query("SELECT * FROM test WHERE modelKodu='{$item['modelKodu']}'")->fetchAll(2);
foreach ($q as $key => $value) {
$number = $key + 1;
$db->query("UPDATE test SET sss = '$number' WHERE id = '{$value['id']}'");
}
}