Yes, but you don't have to use your Costco card to pay. Assuming your Costco takes Apple pay at the pump, you should be able to do that.
I just got back from Costco and they're still not taking Apple Pay at the pump. I did use it at the optical dept and the regular checkout though.