assume the photos are in a separate table, members are allowed more than one photo, and you want to retrieve the photo that the member has marked as primary
, 'photo_pending_review.jpg') AS photo
, 'Pending') AS photo_label
ON photos.member_id = member.id
AND photos.primary = 1
AND photos.photo_approved = 1
WHERE member.id = ?