This one on Amazon seems to work for me, just need an OTG adapter.
Why not just buy a usb dongle that had no length like a flash drive instead?
https://www.amazon.com/dp/B01MTU9KTF/
(I've never tried the above product nor have any affiliation)
Maybe combine it with a short usb extension cord if you really need to, although at that point I'm questioning why not go with your original option and just bundle the cord nicely, and all of these are probably tiny compared to whatever computer your going to be connecting this to
Edit: just saw that you need USB (why?) So that won't work as expected.
Instead, try https://www.amazon.com/dp/B01MTU9KTF/ref=cm_sw_r_cp_awdb_imm_KW3V86BC1REWQTGFGK9M
Good luck.