Retrieve last message between multiple users and display it in inbox

Hello friends today I am going to tell you how to display last conversation in Inbox. For example: In whatsapp chat list we can see the last conversation of each user. Here also we will display last conversation from the chat list.

Below you can see the chat list of A with multiple users. This is the message table below.

Instead of writing code for it and to make it much more easier I have added  one more column message_token, which will help to group last conversation by time. 

Now you can get the last conversation easily by writing the simple query below:

SELECT * FROM (SELECT message_token, MAX(created) AS created FROM messages GROUP BY message_token) AS x JOIN messages USING (message_token, created) where (from_user ='A' OR to_user = 'A') order by date_time desc

Output of the query is:

Thanks for reading