我创建了一个创建项目列表的方法，但并不是每个值都被填充。我尝试了几种方法，但都没有解决这个问题。我尝试了if else语句，但它没有解决这个问题。我得到的值仍然比预期的少。有人能给予我一个提示或重写我的方法吗，这样我就可以回到我的项目了。
方法：

public function getDataListItems(int $category, array $list) 
{
    global $dbh;

    $query = 'SELECT data.value, data.uid, fields.name 
              FROM data 
                JOIN fields ON data.field_id = fields.id 
              WHERE fields.category_id = "' . trim($category) . 
            '" ORDER BY uid';

    $sql = $dbh->prepare($query);
    $sql->execute();
    $values = $sql->fetchAll(PDO::FETCH_ASSOC);

    $data = '';
    $items = [];
    foreach ($values as $value) {
        foreach ($list as $key) {
            if(!empty($data)){
                if($data == $value['uid']) {
                    if($key == $value['name']) {
                        $item = [
                            $value['name'] => $value['value'],
                            'uid' => $value['uid'],
                        ];
                    }else{
                        $item = [
                            $key => '',
                            'uid' => $value['uid'],
                        ];          
                    }
                    $items[$value['uid']] = array_merge($items[$value['uid']], $item);
                }else{
                    if($key == $value['name']) {
                        $items[$value['uid']] = [
                            $value['name'] => $value['value'],
                            'uid' => $value['uid'],
                        ];  
                    }else{
                        $items[$value['uid']] = [
                            $key => '',
                            'uid' => $value['uid'],
                        ];          
                    }       
                }
            }else{
                if($key == $value['name']) {
                    $items[$value['uid']] = [
                        $value['name'] => $value['value'],
                        'uid' => $value['uid'],
                    ];  
                }else{
                    $items[$value['uid']] = [
                        $key => '',
                        'uid' => $value['uid'],
                    ];          
                }       
            }
            $data = $value['uid'];
        }
    }
    return $items;  
}

在$list中，您将找到：

array(3) {
  ["Voornaam"]=> string(8) "Voornaam"
  ["Achternaam"]=> string(10) "Achternaam"
  ["Initialen"]=> string(9) "Initialen"
}

在$values中，您将找到：

array(7) {
  [0]=>
  array(3) {
    ["value"]=> string(7) "Bettina"
    ["uid"]=> string(15) "7d1f4f8e906245f"
    ["name"]=> string(8) "Voornaam"
  }
  [1]=>
  array(3) {
    ["value"]=> string(3) "Les"
    ["uid"]=> string(15) "7d1f4f8e906245f"
    ["name"]=> string(10) "Achternaam"
  }
  [2]=>
  array(3) {
    ["value"]=> string(6) "Simone"
    ["uid"]=> string(15) "7d1f4f8e906245g"
    ["name"]=> string(8) "Voornaam"
  }
  [3]=>
  array(3) {
    ["value"]=> string(4) "Yül"
    ["uid"]=> string(15) "7d1f4f8e906245l"
    ["name"]=> string(10) "Achternaam"
  }
  [4]=>
  array(3) {
    ["value"]=> string(6) "Joshua"
    ["uid"]=> string(15) "7d1f4f8e906245s"
    ["name"]=> string(8) "Voornaam"
  }
  [5]=>
  array(3) {
    ["value"]=> string(3) "Mas"
    ["uid"]=> string(15) "7d1f4f8e906245s"
    ["name"]=> string(10) "Achternaam"
  }
  [6]=>
  array(3) {
    ["value"]=> string(5) "Hello"
    ["uid"]=> string(15) "gGcYEJdRYJ1vqcn"
    ["name"]=> string(10) "Achternaam"
  }
}

我得到的回报是：

["7d1f4f8e906245f"]=>
  array(4) {
    ["Voornaam"]=> string(0) ""
    ["uid"]=> string(15) "7d1f4f8e906245f"
    ["Achternaam"]=> string(3) "Les"
    ["Initialen"]=> string(0) ""
  }
["7d1f4f8e906245g"]=>
  array(4) {
    ["Voornaam"]=> string(6) "Simone"
    ["uid"]=> string(15) "7d1f4f8e906245g"
    ["Achternaam"]=> string(0) ""
    ["Initialen"]=> string(0) ""
  }
["7d1f4f8e906245l"]=>
  array(4) {
    ["Voornaam"]=> string(0) ""
    ["uid"]=> string(15) "7d1f4f8e906245l"
    ["Achternaam"]=> string(4) "Yül"
    ["Initialen"]=> string(0) ""
  }
  ["7d1f4f8e906245s"]=>
  array(4) {
    ["Voornaam"]=> string(0) ""
    ["uid"]=> string(15) "7d1f4f8e906245s"
    ["Achternaam"]=> string(3) "Mas"
    ["Initialen"]=> string(0) ""
  }
  ["gGcYEJdRYJ1vqcn"]=>
  array(4) {
    ["Voornaam"]=> string(0) ""
    ["uid"]=> string(15) "gGcYEJdRYJ1vqcn"
    ["Achternaam"]=> string(5) "Hello"
    ["Initialen"]=> string(0) ""
  }
}

我所期望的结果数组：

["7d1f4f8e906245f"]=>
  array(4) {
    ["Voornaam"]=> string(0) "Bettina"
    ["uid"]=> string(15) "7d1f4f8e906245f"
    ["Achternaam"]=> string(3) "Les"
    ["Initialen"]=> string(0) ""
  }
["7d1f4f8e906245g"]=>
  array(4) {
    ["Voornaam"]=> string(6) "Simone"
    ["uid"]=> string(15) "7d1f4f8e906245g"
    ["Achternaam"]=> string(0) ""
    ["Initialen"]=> string(0) ""
  }
["7d1f4f8e906245l"]=>
  array(4) {
    ["Voornaam"]=> string(0) ""
    ["uid"]=> string(15) "7d1f4f8e906245l"
    ["Achternaam"]=> string(4) "Yül"
    ["Initialen"]=> string(0) ""
  }
  ["7d1f4f8e906245s"]=>
  array(4) {
    ["Voornaam"]=> string(0) "Joshua"
    ["uid"]=> string(15) "7d1f4f8e906245s"
    ["Achternaam"]=> string(3) "Mas"
    ["Initialen"]=> string(0) ""
  }
  ["gGcYEJdRYJ1vqcn"]=>
  array(4) {
    ["Voornaam"]=> string(0) ""
    ["uid"]=> string(15) "gGcYEJdRYJ1vqcn"
    ["Achternaam"]=> string(5) "Hello"
    ["Initialen"]=> string(0) ""
  }
}

您可以看到，我在返回列表中遗漏了一些值。