CODE EXAMPLE FOR SQL

mysql concat two columns laravel eloquent

public function users()
{
    $users = DB::table('users')->select('id', DB::raw("CONCAT(users.first_name,' ',users.last_name) AS full_name"))->get()->pluck('full_name', 'id');

    return view('users',compact('users'));
}