id_, scheme_id_, subject_id_, nature_, name_, code_, contents_, mode_, target_value_, unit_, weight_, sn_, memo_ SELECT si.*, s.name_ AS schemeName FROM kh_scheme_indicators si LEFT JOIN kh_scheme s ON s.id_ = si.scheme_id_ WHERE si.scheme_id_ = #{schemeId}