Обмен сообщениями

$get = DB::table('messages_messages')->where('from_id', session('user_id'))->orWhere('to_id', session('user_id'))
    ->limit(1)->get();
var_dump($get);

if (!session()->has('user_id')) {
    throw new \Exception('User ID not found in session');
}
 
$get = DB::table('messages_messages')
    ->where(function($query) {
        $query->where('from_id', session('user_id'))
              ->orWhere('to_id', session('user_id'));
    })
    ->orderBy('created_at', 'desc') // берем последнее по времени созданное сообщение
    ->limit(1)
    ->get();
 
var_dump($get);

<?php
namespace App\Http\Controllers;
use Session;
use DB;
use Crypto;
use Lang;
use Log;
class MessagesController extends Controller {
 
public function getMessages($room_id){
$get = DB::table('messages_messages')
    ->where(function($query) {
        $query->where('from_id', session('user_id'))
              ->orWhere('to_id', session('user_id'));
    });
    $get = json_decode(json_encode($get),true);
    $result=array();
    foreach($get as $v){
        $row1['data']=$v;
        $owner_info=DB::table('users')->where('id',session('user_id'))->get();
        $owner_info=json_decode(json_encode($owner_info),true);
        $row1['owner_info']=$owner_info;
        $row1['date_created']=parseTimestamp($v['timestamp_created']);
        $result[]=$row1;
    }
    return view('messages.get_messages', ['dialogs'=>$result]);
}
 
public function messages(){
$get = DB::table('messages_messages')->where('from_id', session('user_id'))
              ->orWhere('to_id', session('user_id'))->get();
    $get = json_decode(json_encode($get),true);
    $result = array();
    foreach($get as $v){
        $row1['data']=$v;
        $owner_info=DB::table('users')->where('id',session('user_id'))->get();
        $owner_info=json_decode(json_encode($owner_info),true);
        $row1['owner_info']=$owner_info;
        $row1['date_created']=parseTimestamp($v['timestamp_created']);
        $result[]=$row1;
    }
 
 
   return view('messages.messages', ['messages'=>$result]); 
}
 
}

$get = json_decode(json_encode($get),true);
    $result=array();
    foreach($get as $v){

DB::table('messages_messages')->where([
    ['from_id', '=', $userId1],
    ['to_id', '=',  $userId2],
])->orWhere([
    ['from_id', '=', $userId2],
    ['to_id', '=', $userId1],
]);

  $get = DB::table('im')->where('to_id',session('user_id'))->orWhere('from_id',$_GET['from_id'])->get();