PHP for循环在2次循环后停止获取MYSQL表行

Question

我有一个特殊的问题。我正在尝试使用for循环将表产品中的行（共有5条）放入php数组（$ ro）中。我的代码成功完成了前2个循环，并确认数组中有5行。但是，放入数组中的第二行实际上是表中的第三行，就像我说的那样，在第二个循环之后，我的函数停止获取行。我测试了打印我的数组和ID并得到以下结果：1=>Array ( [sku] => JVC200123 [name] => Acme DISC [price] => 1.00 [type] => disc [value] => 700 ) 2=>Array ( [sku] => GGWP0008 [name] => Preacher [price] => 24.99 [type] => book [value] => 1 ) ...345我想念什么？这是有问题的代码：protected function get_prod($conn1){    $pluck_type = array();    $objects = array();    $call_type = 'SELECT id, type FROM products ORDER BY id';    $type_res = mysqli_query($conn1, $call_type);    $index = 0;    while($row = mysqli_fetch_assoc($type_res)){         $pluck_type[$index] = $row;        $index++;    }    for ($roww = 0; $roww < count($pluck_type); $roww++) {        $product_type = $pluck_type[$roww]['type'];        $rowid = $pluck_type[$roww]['id'];        if($product_type == 'disc')        {            $sql = "SELECT p.sku, p.name, p.price, p.type, a.value FROM products AS p INNER JOIN attr_size AS a ON p.id = a.product_id WHERE a.id = '".$rowid."';";            echo $rowid;        }        else if ($product_type == 'book')        {            $sql = "SELECT p.sku, p.name, p.price, p.type, a.value FROM products AS p  INNER JOIN attr_weight AS a ON p.id = a.product_id WHERE a.id = '".$rowid."';";            echo $rowid;        }        else if ($product_type == 'furniture')        {            $sql = "SELECT p.sku, p.name, p.price, p.type, CONCAT(a.height, 'x', a.width, 'x', a.length) AS value FROM products AS p  INNER JOIN attr_dims AS a ON p.id = a.product_id WHERE a.id = '".$rowid."';";            echo $rowid;        }        $val_res = mysqli_query($conn1, $sql);        $ro = mysqli_fetch_assoc($val_res);        print_r($ro);        $objects[$roww] = $ro;     }    $this->objekt = $objects;}