select() ->from('hoststatus', [ 'host_name', 'host_address', 'host_address6' ]); if ($filter !== null) { $hosts->applyFilter($filter); } foreach ($hosts as $host) { if (! empty($host->host_address)) { yield $host->host_address => $host->host_name; } if (! empty($host->host_address6)) { yield $host->host_address6 => $host->host_name; } } } }