如何从laravel中的两个表中选择行并将它们作为单个列表返回

I have two tables,one is called patient_payments and the other is patient_billing.i now want to select all the rows from each table and then present them as a single list in my webpage.I am using laravel framework and i have used raw query as follows

$items = DB::select(DB::raw('select * from patient_payments pp,patient_billings pb'));

One table has three rows and the other five rows and i was expecting two get eight rows but the query returns 14 rows which is wrong.Any idea what is wrong with my query is much appreciated.

Thanks in advance

If both tables have the same number of columns, you can use union() method like this:

$items = DB::table('patient_payments')
    ->union(DB::table('patient_billings'))
    ->get();

Read more about Laravel Query Builder: union() here.

Hope this help.