mybatisPlus 使用mapper多表多连接查询

这个问题花了我3个小时，。先上图，以后再解释

<select  parameterType="List" resultType="hashMap">
		select
		job.*,
		 as catname1,
		 as catname2,
		 as catname3,
		province.area_name as addr_province,
		city.area_name as addr_city,
		area.area_name as addr_area,
		 as jingyan,
		 as xueliname
		from
		mj_com_job job
		left join mj_job_class jobclass1 on job.cat1=
		left join mj_job_class jobclass2 on job.cat2=
		left join mj_job_class jobclass3 on job.cat3=
		left join mj_area province on  = 
		left join mj_area city on  = 
		left join mj_area area on job.three_cityid = 
		left join mj_com_class jingyan on job.experience_id=
		left join mj_com_class xueli on job.Education_id=
		<where>
			${}
		</where>
	</select>

    public R detail(@RequestParam(value = "jobid") Integer jobid, Model model) {
        QueryWrapper<ComJob> wrapper = new QueryWrapper<>();
        ("",jobid);
        List<ComJob> comJob = (wrapper);