left join后分组显示主表的保留单条数据的值，和子表的数据保留处理

group 之后的 group_concat函数

	<sql id="selectMerchantVo">

		SELECT
			GROUP_CONCAT(
					CONCAT(
							CASE
								WHEN mc.channel_code = 'cashpay' THEN '代付通道antpay,'
								ELSE '代收通道antwith,'
								END,
							'费率:',
							mc.settle_rate,
							'固定费:',
							COALESCE(mc.settle_fee, '0') -- 假设settle_fee可能是NULL，这里用'0'作为默认值
						)
						ORDER BY mc.id
        SEPARATOR ','
				) AS showpaywith,
			m.id,
			m.create_time,
			m.relevance_account_username,
			m.redirect_url,
		    m.name,
		    m.merchant_num,
			m.notify_url,
			m.relevance_account_id,
			m.version,
			m.limit_ip,
			m.public_key,
			m.private_key,
			m.encrypt_type
		FROM
			merchant m
				LEFT JOIN
			merchant_chnl_setting mc
			ON
				mc.merchant_id = m.id




	</sql>
	<select id="allMerchantList" resultType="com.ruoyi.runscore.domain.vo.AgentMerchantVo">
		select id, name from merchant
	</select>
	<select id="selectMerchantList" parameterType="Merchant" resultMap="MerchantResult">
		<include refid="selectMerchantVo"/>
		<where>
			<if test="name != null  and name != ''"> and name like concat('%', #{name}, '%')</if>
			<if test="params.beginCreateTime != null and params.beginCreateTime != '' and params.endCreateTime != null and params.endCreateTime != ''"> and create_time between #{params.beginCreateTime} and #{params.endCreateTime}</if>
		</where>
			GROUP BY
		m.id
	</select>