ID_, PLAN_ID_, PATROL_ID_ SELECT p.*,d.PLAN_ID_ FROM biz_base_patrol p LEFT JOIN biz_inspection_plan_details d on d.PATROL_ID_ = p.ID_ WHERE d.PLAN_ID_ = #{planId}