SELECT 
msg.content,
snd_user.username,
rcv_user.username
FROM
messages as msg
LEFT OUTER JOIN
users as snd_user 
ON
msg.senderid = snd_user.userid
LEFT OUTER JOIN
users as rcv_user 
ON
msg.receiverid = rcv_user.userid;