select u.uye_id, h.hizmet_bitis .......
from hizmetler h 
join uyeler u on h.uye_id = u.uye_id
where h.hizmet_bitis < now()- 15 day