public function queryInitiator(Request $request) { $queryInitiatorName = $request->name; $initiatorIds = StakeholderTranslation::where('org_name', 'like', '%' . $queryInitiatorName . '%')->lists('stakeholder_id'); $initiators = Stakeholder::whereIn('id', $initiatorIds)->orWhere('name', 'like', '%' . $queryInitiatorName . '%')->with(['translations'])->get(); $result = []; foreach ($initiators as $initiator) { $result[] = ['id' => $initiator->id, 'name' => $initiator->name ? $initiator->name : $initiator->org_name]; } return $result; }