对于e.x.，您可以像这样删除空字段。

<pre><?php

// Source before
$before = array();
$before[] = array("1" => "germany");
$before[] = array("1" => "usa");
$before[] = array("2" => "usa");
$before[] = array("2" => "");

print_r($before);

// Source after
$after = array();
foreach ($before as $key => $value) {
    // Only add value, if aviable
    foreach ($value as $key2 => $value2) {
        if (!empty($value2)) {
            $after[] = array($key2,$value2);
        }
    }
}
print_r($after);

结果：

Array
(
    [0] => Array
        (
            [1] => germany
        )

    [1] => Array
        (
            [1] => usa
        )

    [2] => Array
        (
            [2] => usa
        )

    [3] => Array
        (
            [2] => 
        )

)
Array
(
    [0] => Array
        (
            [0] => 1
            [1] => germany
        )

    [1] => Array
        (
            [0] => 1
            [1] => usa
        )

    [2] => Array
        (
            [0] => 2
            [1] => usa
        )

)

您可以在存储库中使用QueryBuilder来完成此操作。

$qb = $this->createQueryBuilder('your_alias')
            ->select('your_alias.id, your_alias.origin');

        $qb
            ->where('your_alias.origin IS NOT NULL')
            ->orderBy('your_alias.id');

        return $qb->getQuery()->getResult();

此致，