query->columns(User::TABLE.'.id', User::TABLE.'.username', User::TABLE.'.name')->findAll(); foreach ($users as &$user) { $user['value'] = $user['username'].' (#'.$user['id'].')'; if (empty($user['name'])) { $user['label'] = $user['username']; } else { $user['label'] = $user['name'].' ('.$user['username'].')'; } } return $users; } }