SELECT u.ProfilePic AS FriendPic, u.UserName AS FriendName, m.*
FROM (SELECT PhotographerId
      FROM Messages
      WHERE UserId=? OR PhotographerId=?
      GROUP BY PhotographerId
     ) AS m JOIN
     User AS u
     ON u.UserId = m.PhotographerId;