how to list all users based on their groups

[ahmaruff]

I want query all users based on their groups. e.g list all users where group = superadmin. but when I try, it return errors Unknown column 'groups' in 'where clause'

$userModel = new UserModel();
$users = $userModel->where('groups', 'superadmin')->findAll();
foreach($users as $u) {
       var_dump($u);
       echo "<hr>";
}
die();

so how to do this? thankyou

[kenjis]

Group data is stored in auth_groups_users table.
See

shield/src/Database/Migrations/2020-12-28-223112_create_auth_tables.php

Lines 112 to 121 in 697f570

	// Groups Users Table
	$this->forge->addField([
	'id' => ['type' => 'int', 'constraint' => 11, 'unsigned' => true, 'auto_increment' => true],
	'user_id' => ['type' => 'int', 'constraint' => 11, 'unsigned' => true],
	'group' => ['type' => 'varchar', 'constraint' => 255, 'null' => false],
	'created_at' => ['type' => 'datetime', 'null' => false],
	]);
	$this->forge->addPrimaryKey('id');
	$this->forge->addForeignKey('user_id', 'users', 'id', '', 'CASCADE');
	$this->forge->createTable('auth_groups_users');

[lonnieezell]

Bonfire has implemented this as part of a filter, but here's the relevant code which would translate to something like:

$users = $userModel
    ->select('users.*)
    ->join('auth_groups_users agu', 'agu.user_id = users.id')
    ->whereIn('agu.group', 'superadmin')
    ->findAll();

[ahmaruff]

thank you. this solution help me. i'all mark this as an answer :)