Is it possible to make such a join request?

Question

MySQL

Previously, the data was formed in the following way:

UserData::where('user_id', '=', Auth::user()->id)
            ->join(DB::raw('element as e'), 'e.field_name', '=', 'users_data.field_name')
            ->join(DB::raw('section as s'), 's.section_id', '=', 'e.section_id')
            ->select([
                'users_data.field_name',
                'users_data.data',
                's.permission_group',
                'e.element_label',
                's.section_id',
            ])
            ->get()

That is, we got all the user data from the table and added data from the section and element table to them
. Now we need to get data from element, add section and users_data to them.
In the first case, in section and element there is always data for users_data
However, in the new logic, there may not be data in users_data, so where there is no data 'users_data.field_name' and 'users_data.data' we should just leave it empty
. Actually, can it exist? such a join request?
PS It is not possible to check now, that's why I'm asking here

Answer 1