问使用jooq时出现未知列sql错误

EN

this.dslContext.select(
            ROLE.asterisk(),
            multiset(
                select(PERMISSION.asterisk())
                    .from(ROLE_PERMISSION)
                    .innerJoin(PERMISSION)
                    .on(ROLE_PERMISSION.PERMISSION_ID.eq(PERMISSION.ID))
                    .where(ROLE_PERMISSION.ROLE_ID.eq(ROLE.ID))
            ).as("permissions")
        ).from(ROLE)
            .where(ROLE.ID.eq(id))
            .fetchOneInto(Role.class)

jOOQ; bad SQL grammar [set @t = @@group_concat_max_len; set @@group_concat_max_len = 4294967295; select `users`.`role`.*, (select coalesce(json_merge_preserve('[]', concat('[', group_concat(json_array(`v0`, `v1`) separator ','), ']')), json_array()) from (select `users`.`permission`.`id` as `v0`, `users`.`permission`.`name` as `v1` from `users`.`role_permission` join `users`.`permission` on `users`.`role_permission`.`permission_id` = `users`.`permission`.`id` where `users`.`role_permission`.`role_id` = `users`.`role`.`id`) as `t`) as `permissions` from `users`.`role` where `users`.`role`.`id` = ?; set @@group_concat_max_len = @t;]; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'users.role.id' in 'where clause'.