well i think the message would have the recipient/sender not the
conversation. the conversation is a one to many of conversation ->
i think you need to decide one way or the other if the messages have
many users that are recipients or has_many users that are senders. I
dont think you can have both. Although you could have two fields in
the messages table that hold user_id , and do separate left joins on
them. 1 to get the sender and one to get the recipient.
so in your messages table there would be a user_id field which would
be the sender of the message. You would also put a recipient_id field
, which would be a user_id as well , however this would hold the
select * from messages left join users on messages.user_id = users.id
select * from messages left join users on messages.recipient_id =
make sense ?