从sql查询加载用户-正确的方法

我有一个sql查询,它列出了 uid 在所有具有特定角色的用户中:

SELECT u.uid 
FROM {users} as u, {users_roles} as ur 
WHERE u.uid = ur.uid AND ur.rid = 10 ORDER BY u.uid DESC

我需要将它们作为列表对象加载到一个数组中。

我问了一个 question previously 我只知道我想做的事情会更容易 没有视图 -所以我要用一个模板文件代替。
所以这个问题。

我知道怎么做,但显然 method is worth -2

我想这样做:

$research['sql']   = "SELECT u.uid FROM {users} as u, {users_roles} as ur WHERE u.uid = ur.uid AND ur.rid = 10 ORDER BY u.uid DESC";
$research['sql_result'] = db_query($alumni['sql']);

// Load user objects and store in array
while($user_array = db_fetch_array($research['sql_result'])) {
  // Create user objets based on uid
  $user_obj = user_load($user_array['uid']);

  // Load profile
  profile_load_profile($user_obj);
  $research['users'][$user_obj->uid] = $user_obj;
}

请帮助我 应该 去做吧。