alias("au") ->field("au.*,wt.title as user_work_type_title,s.title as service_time_type_title") ->leftJoin("user_work_type wt" , "wt.id = au.user_work_type_id")//职称 ->leftJoin("service_time_type s" , "s.code = au.service_type")//服务时长类型 ->where($where) ->order("au.id","desc") ->find(); } }