问如何基于laravel查询生成器编写mysql查询

EN

select specialization_master.sm_specializationtype from 
specialization_master 
join hospital_profile_master on FIND_IN_SET(specialization_master.sm_id ,  (select hospital_profile_master.hp_specialization from hospital_profile_master where hp_hospitalid = 'HOS10011'))
group by specialization_master.sm_specializationtype

$query_filter_dept_list = DB::table('specialization_master')
                            ->join('hospital_profile_master',DB::raw(FIND_IN_SET(specialization_master.sm_id , (select hospital_profile_master.hp_specialization from hospital_profile_master where hp_hospitalid = $hospital_id))))
                            ->select('specialization_master.sm_specializationtype')
                            ->groupBy('specialization_master.sm_specializationtype')
                            ->get();