用户D1156960(提问者)SELECT
count( member_id ) as a,
a.travel_city_id
FROM
(SELECT DISTINCT ( member_id ),
travel_city_id
FROM
ads_brand_contact
WHERE
is_member = 1
AND date_format( now( ), \'%Y-%m-%d\' ) = substr( register_time, 1, 10 )
) a
where travel_city_id in (\'${travel_city_id}\')
这样写有问题吗