$query = "SELECT * FROM urunler INNER JOIN kategori ON urunler.urun_katid = kategori.kategori_id WHERE urun_link = :urun_link";
    $statement = $db->prepare($query);
    $statement->bindParam(':urun_link', $sef);
    $statement->execute();
    $result = $statement->fetch(PDO::FETCH_ASSOC);