Topic: Get All The Users with certain values


Currently I'm using following code to get the user profiles which returns each user separately or if I use for loop on "id" it generates list:

Users::$users = new Table('users');
                ->assign('user', Users::$users->select("[id='1']", null))

I want to generate profiles of all the users with value "Admin". e.g. there is <role>Admin</role> in database. I want all the profiles that have this value to be generated.
How do I do that?