Like this event select members.name as member,member_images.image as image from events join dist_likes on events.id=dist_likes.event join members on members.id=dist_likes.member left join member_images on member_images.id=members.image_id where events.id=206;9 like this