Sql select columns from different tables

Questions Components & MVC
2 
        $sql = new Sql($adapter);
        $select = $sql->select();
        $select->from('users');
        $select->columns([
            'user_id',
        ]);
        $select->join('role_user', 'users.user_id = role_user.user_id', [], $select::JOIN_LEFT);
        $select->join('roles', 'roles.role_id = roles_user.role_id', ['role_name'], $select::JOIN_LEFT);
        $select->where(['user_id' => $userId]);

3 params - field for select from join table

1 Like