SQL计数客户的不同访问，开放时间从上午10点到6点

I am writing a customer loyalty software for a club that opens from 10am to 6am everyday. The data is store in MYSQL and I'd like to count the customer's total visits for the month. I am writing a customer loyalty software for a