How to display last message in laravel?

Question

Laravel

It is necessary to display the last message from a particular dialog on a separate page of all dialogs, like VK.
I have a "chats" table where the last message id (chat) between two users is the last message. Accordingly, something like this should turn out in the controller:

$last_message = Chat::get('chat')->where('id') самое большое между user_id и friend_id конкретного диалога;

where chat - the content of the message
user_id - the first user
friend_id - the second user Tell me
how to write the end of the code?

Answer 1

$last_message = Chat::where('user_id', $user_id)
    ->where('friend_id', $friend_id')
    ->orderBy('id', 'desc')
    ->first()
    ->chat;