<select id="" resultMap="">
SELECT
a.fid AS fid,
b.fclass AS fclass
c.fname AS fname
from t_demo_1 a
LEFT JOIN t_demo_2 b ON a.fid=b.fid
LEFT JOIN t_demo_3 c ON b.fclass=c.fclass
WHERE a.facc_id='23232'(#{accountId,jdbcType=VARCHAR})
AND f..=1
</select>