SELECT y.*, r.id as rid, r.baslik, u.id as uid, u.kulresim, u.kuladsoyad
from yorum y
inner join resim r on r.id = y.resimid
inner join uye u on u.id = y.uyeid
where y.uyeid = $id
order by y.id desc limit 10