Laravel join from two tables including null

I have 3 tables root, child_1, child_2.

root table:

id | child_1_id | child_2_id ...|

child_1_id/child_2_id is nullable !

child_1 table:

id | child_2_id | name | ...|

child_2 table:

id | name ...|

root table has foreign keys to child_1 and child_2. The relation for both is one child_1 or child_2 to many roots.

child_1 table has foreign key child_2_id and relation one child_2 to many child_1.

I want to select everything from child_1 and child_2 and count rows from root table for each child_1/child_2, where I can:

foreach($elems as $elem){
    
}

$elems = collection => name=> column from child_1 or child_2 | all => COUNT rows for current child_1/child_2.

I am using the latest Laravel version with MySQL.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2RIv2yw
via IFTTT