bunu dener misin

if ( $query->rowCount() ) {
foreach ($query as $row) {

$say=$say+1;    

if($say==4){
echo "<li class='clasadinigiriniz' ><a href='#'>{$row['link_name']}</a></li>";    
    
    }else{    
echo "<li><a href='#'>{$row['link_name']}</a></li>";

}

}

}