SELECT
t.dict_code,
m.*,
t.label itemName,
t.VALUE itemValue
FROM
t_base_dict_val t
LEFT JOIN (
SELECT
d.content,
d.type,
minfo.years,
minfo.dept_id,
d.is_del
FROM
eval_dept_info d
JOIN eval_dept_main_info minfo ON d.main_info_id = minfo.id
) m ON m.type = t.`value`
AND m.dept_id = 8
AND m.years = 2019
WHERE
t.dict_code = 'evaluateType'
AND (m.is_del = 0 OR m.is_del IS NULL)
/////////////只能 left join 一次///////////////
