'How to sub query a select into another select and put inside a variable with laravel?

I want to make a select that solves the fact that I have to perform two validations one for each table, what i'm doing now is validating the $table1 and validating the $table2 ,i just want to validate $table2

$table1 = DB::table('name_table1')
->where('invoice_id','{$table2}.id')
->get();

$table2 = DB::table('name_table2')
->select('name','invoices','{$table} as itens_of_invoice')
->get();
dd($table);

And return me something like;

    Array (
[0] => Object(
    'name' => 'value_name',
    'invoices' => 'value_invoices',
    'item_of_invoice' => 
        Array( 
            [0] => Array( 
                'name_item' => 'value_name',
                'price' => 'value_price'
            )
        )
)
[1] => Object(
    'name' => 'value_name',
    'invoices' => 'value_invoices',
    'item_of_invoice' => 
        Array( 
            [0] => Array( 
                'name_item' => 'value_name',
                'price' => 'value_price'
            )
        )
)
[2] => Object(
    'name' => 'value_name',
        'invoices' => 'value_invoices',
    'item_of_invoice' => 
        Array( 
            [0] => Array( 
                'name_item' => 'value_name',
                'price' => 'value_price'
            )
        )
)

)

I don't find any solution if someone ever did this please help me



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source