Is there a way to filter selected data based on the multi-valued attributes of a Mjoin ?

Error messages shown: An SQL error occurred: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'roles.id_account' in 'where clause'
Description of problem:
My problem is the following :
I have a user tables, a role table, a N-N table in between 'users_roles'. The table role has an id account for 1-N relationship with the account table. In this scope account denote an organisation. A user is part of one or multiple accounts depending on the role he has that are part of an account.
I am trying to create an editor on my users. So I work on my table user, I use an Mjoin to get the array of roles this user posesses. But then I need to filter the user based on permissions.
Then I have a list of permitted accounts. I am trying to add a where clause to my editor in order to fetch only users that have at least 1 role with an id_account attribute that is part of the $permittedAccounts. In the where statement I use permittedAccountsSQL which is a string of accounts id such as "('1', '3')" to match with in statement.

I tried different variations but the recurring issue is that 'roles.id_account' is not accessible outside of the scope of the Mjoin->fields. Hence I have a "Column not found error"

        $thisEditor = Editor::inst($this->editorDb, 'user')
            ->fields(
                Field::inst('user.id')->set(false),
                Field::inst('user.username')->validator('Validate::notEmpty'),
                Field::inst('user.realname'),
                Field::inst('user.description'),
            );
        $thisEditor->join(
            Mjoin::inst('roles')
                ->link('user.id', 'users_roles.id_user')
                ->link('roles.id', 'users_roles.id_role')
                ->order('id desc')
                ->fields(
                    Field::inst('id')->options(Options::inst()
                        ->table('roles')
                        ->value('id')
                        ->label('title')
                    ),
                    Field::inst('roles.title'),
                    Field::inst('roles.description'),
                    Field::inst('roles.id_account')
                        ->options(Options::inst()
                            ->table('account')
                            ->value('id')
                            ->label(array('company_name', 'id'))
                            ->render(function ($row) {
                                return $row['company_name'] . ' (' . $row['id'] . ')';
                            })
                            ->order('id DESC')
                        ),
                )
        );
        $thisEditor->where(function ($q) use ($permittedAccountsSQL) {
            $q->where('roles.id_account', $permittedAccountsSQL, 'IN', false);
        });
        $thisEditor->process($post)->json();