php - how to merge 2 same collections in larave

Question

consider on first query i get 2 rows and on 2nd query i get 1 row i want to 2+1 = 3 rows into a single collection so that i can have all the data here is my query

 $invoices = Invoice::whereIn('user_id', $ids)->get(); //have data in column id 1 and 2
    $stock = Invoice::where('customer_id' , Auth::id())->get(); // have data in column id 3 
    $merge = //how i can merge this?

now consider i merged both my output should be using foreach

foreach($merge as $a){
$b[] = $a->id;
}
dd($b);

output should be [1,2,3]

question from:https://stackoverflow.com/questions/65942825/how-to-merge-2-same-collections-in-larave

Answer 1

you can get the both result in one query using orWhere:

$mergedResult=Invoice::whereIn('user_id', $ids)->orWhere('customer_id' , Auth::id())->get();