title: Concatenate two field into a alias name laravel
body: <pre><code>$data = DB::table('tables')
      -&gt;select('orders.order_id', 'users.*')
      -&gt;leftJoin('lists', 'lists.order_id', '=', 'orders.order_id')
      -&gt;leftJoin('users', 'users.user_id', '=', 'lists.user_id')
      -&gt;where('users.type', '=', 'admin')
      -&gt;get();
  
  dd($data);
  </code></pre>
  
  <p>getting first_name and last_name how can i group those i.e alias says full_name
  fullname => Max jones</p>
  
  <p>Concatenate two field into a alias name laravel</p>