public function queryIssue(Request $request) { $queryIssueName = $request->input('name'); $issueIds = IssueTranslation::where('name', 'like', '%' . $queryIssueName . '%')->where('locale', \App::getLocale())->lists('issue_id'); $issues = Issue::whereIn('id', $issueIds)->with(['translations'])->get(); $result = []; foreach ($issues as $issue) { $result[] = ['id' => $issue->id, 'name' => $issue->name]; } return $result; }