public function queryDomain(Request $request) { $queryDomainName = $request->input('name'); $domainIds = DomainTranslation::where('name', 'like', '%' . $queryDomainName . '%')->where('locale', \App::getLocale())->lists('domain_id'); $domains = Domain::whereIn('id', $domainIds)->where('parent_id', '>', 0)->with(['translations', 'parent'])->get(); $result = []; foreach ($domains as $domain) { $result[] = ['id' => $domain->id, 'name' => ($domain->parent->id > 1 ? $domain->parent->name . " - " : "") . $domain->name]; } return $result; }