How to display correspondence in pairs?

Question

MySQL

Hello!
There is a table " messages " (id, from_id, to_id, message, read, timestamps)
And I need to display the correspondence between users by pair.
My query turns out like this:

Message:where('from_id', $id)->orWhere('to_id', $id)->get();//получаем кому он отправлял и от кого получал

But I can’t group them, for example: the
1st user wrote to the 2nd user , the 2nd user replied to the 1st
In this situation, their roles change, i.e. (from_id = 1st user, to_id = 2nd user) and (from_id = 2nd user, to_id = 1st user)
My request is to display each record separately, but I need to get incoming and outgoing messages in pairs between the recipient and the sender.

Answer 1

SELECT * FROM message WHERE (from=1 AND to=2) OR (from=2 AND to=1)

What is in pairs? If the first user sent the second three messages in a row, and the second did not answer, then everything will break?