select
DISTINCT(xd_user.user_name)
from xd_resource_list
LEFT JOIN xd_course_product
on xd_resource_list.forum_tag = xd_course_product.course_code
LEFT JOIN xd_course_product_order_record
on xd_course_product_order_record.product_id = xd_course_product.id
LEFT JOIN xd_user
on xd_user.id = xd_course_product_order_record.uid
where to_days(xd_resource_list.create_time) = to_days(now());
DISTINCT(xd_user.user_name)
from xd_resource_list
LEFT JOIN xd_course_product
on xd_resource_list.forum_tag = xd_course_product.course_code
LEFT JOIN xd_course_product_order_record
on xd_course_product_order_record.product_id = xd_course_product.id
LEFT JOIN xd_user
on xd_user.id = xd_course_product_order_record.uid
where to_days(xd_resource_list.create_time) = to_days(now());