Trying to recreate the taste of a drink I had last year

So just for the record, I’m new to mixing drinks myself, but this should be pretty simple.

Last year I was in Okinawa and went to a local izakaya where I had a really delicious drink. This was the pic I took of it back then: https://i.imgur.com/MwA7DPg.png

I got it at a place called Entame Kitchen in Naha. It was an Okinawa-limited flavor, so I guess you can’t get it at any restaurants outside the island. The menu has both highballs and sours, and for both they offer the same limited flavors: パインシークワーサー or マンゴーオレンジ; pine(apple) shiikuwasa (citrus) or mango orange.

I’m pretty sure we had the mango/orange because I feel like making a remark of how popular mango flavor was in Okinawa and we decided to go with that. Honestly I may have my receipt from that night still somewhere which would tell me. I can’t recall whether it was a highball or sour, but I’m guessing they use shochu to make the sour, which is near impossible to find in my area. So, I tried making the highball.

Not sure what alcohol they used for it, but I’m going to guess vodka? I don’t remember tasting hardly any alcohol in it at all, but it was definitely there. Presumably you would also just add mango and orange juice, maybe a little bit of lemon? Not sure if it makes much a difference between club soda and sparkling water. After I made it, there was no fizz or foaming at all like in the picture, and it was nowhere near as yellow. Maybe it was too diluted with the club soda, I’m not sure of the exact amounts and ratios.

What else should I try? What am I missing? Also in case anyone is curious, this is the menu: https://www.hotpepper.jp/strJ003595003/drink/