Get latest conversation per user in Laravel

latest_conversation.php

// Using Laravel/Eloquent
$userId = 1;

$messages = Message::select('*')
  ->where(function ($query) use ($userId) {
    $query->where('to_id', $userId)
      ->orWhere('from_id', $userId);
  })
  ->groupBy(DB::raw("CONCAT(LEAST(to_id, from_id), '.', GREATEST(to_id, from_id))"))
  ->selectRaw("MAX(id) as lastid")
  ->get();

$lastIds = $messages->pluck('lastid');

$conversations = Message::whereIn('id', $lastIds)
  ->orderBy('created_at', 'desc')
  ->get();


// using query builder:
$userId = 1;

$messages = DB::table('messages')
  ->where(function ($query) use ($userId) {
    $query->where('to_id', $userId)
      ->orWhere('from_id', $userId);
  })
  ->groupBy(DB::raw("CONCAT(LEAST(to_id, from_id), '.', GREATEST(to_id, from_id))"))
  ->selectRaw("MAX(id) as lastid")
  ->get();

$lastIds = $messages->pluck('lastid');

$conversations = DB::table('messages')
  ->whereIn('id', $lastIds)
  ->orderBy('created_at', 'desc')
  ->get();