java mybatis mapper 中循环查询条件

SELECT
		o.*
	FROM
		u_order o
		LEFT JOIN u_order_goods og ON o.id = og.order_id

	o.is_virtual = 0
	
		AND o.ccode = #{uOrderGoodsVO.ccode}
	
	
		AND og.cinvdefine3 = #{uOrderGoodsVO.cinvdefine3}
	
	
		AND og.cinvdefine5 in
		
			#{item}