$query1 = DB::table('table1')
->select('column1 as name', 'column2 as value')
->where('column1', '=', 'value1');
$query2 = DB::table('table2')
->select('column3 as name', 'column4 as value')
->where('column2', '=', 'value2');
$result = $query1->union($query2)->get();
as...