使从MySQL通过PHP

我正在做一个多维数组，其中包含用户和他们创建的组多维数组，我有两个表的用户和组，我设法让一个数组，我想武官另一个数组让它变得多维，我需要帮助。 这是我所：使从MySQL通过PHP

$sqlusers = $db->query("SELECT * FROM users"); 
$users = array(); 
WHILE($user = mysqli_fetch_array($sqlusers)) 
{ 
    $users[] = array(
     "userName" => $user['name'], 
     "userPhone" => $user['phone'] 
    ); 

    $uid = $user['id']; 
    $sqlgroup = $db->query("SELECT * FROM groups WHERE adminId = '$uid'"); 
    $groups = array(); 
    WHILE($group = mysqli_fetch_array($sqlgroup)) 
    { 
     $groups[] = $group['groupName']; 
    } 
} 
print_r($groups); 
?> 

我需要的结果是这样的：

Array ( 
     [0] => Array ( 
         [userName] => Bebe Claudette 
         [userPhone] => 185022455 
         [userGroup] => Array (
              [groupName] => TestGroup1 
              ) 
        ) 
     [1] => Array ( 
         [userName] => MUHIRWA Clement 
         [userPhone]=> 0785432238 
         [userGroup] => Array (
              [groupName] => TestGroup2 
              ) 
        ) 
    ) 

===========解决方案如下：

用于连接查询，得到的结果为2台。尝试是这样的（未测试）：

SELECT u.*, g.* FROM users as u INNER JOIN groups as g ON u.id = g.adminId; 

现在，如果你遍历你的结果，你会从2个表有数据。