SELECT takip.*, (select kullanici_adi from uye_tablosu where id = takip.takip_eden.id) as takip_eden_kullaniciadi FROM takip WHERE takip_edilen_id = 'a_kisisi_id' AND durum = '1'