left joine gerek yok.

$sor=$db->prepare("SELECT*FROM product where ID=$id");
$sor->execute();
while ( $cek=$sor->fetch(PDO::FETCH_ASSOC)) {
echo $resim;
}