SELECT * FROM GONGSI G LEFT JOIN BUMEN B ON B.GONGSIID = G.ID 棚闷 WHERE G.ID = #{id} 芹和戚 嫌陵
<庆橘猜result property="userName" column="userName"/>
collection 标签里面就是多那个对象