@php use Illuminate\Support\Facades\DB; $mlAccountGroup = \App\Models\AccountGroup::select( DB::raw(" CASE WHEN a_sub_group_name IS NOT NULL THEN CONCAT(a_group_name, '( ', a_sub_group_name, ')') ELSE a_group_name END as a_group_name "), 'id', ) ->pluck('a_group_name', 'id') ->toArray(); $mlCompanyDetails = \App\Models\CompanyProfile::first(); @endphp