I agree with most of the above. Your best option at a reasonable price would be a quality pair of running or walking athletic shoes for general comfort. The second half of that option is to keep that pair dedicated to your pool playing only. Breaking them in by using them for 3 or 4 days under normal use will help also before using them for an 8 hour pool session.
I have two artificial hips so I have been spent plenty of time thinking and dealing with this issue over the years regarding all my activities. I have to wear steel toes at work, and quality matters. I don't buy cheap steel toe boots and it makes a difference.
A more expensive, but in my opinion, a better option is to go to quality light weight hiking boots. My preference is Murrells, but there are plenty of quality specialty hiking boots available at a retailer like REI. All my vacations are camping, and quality boots matter to me.
Then, two other options come to mind. If you're not buying top of the line shoes, then change out the inserts in your shoes or boots with high quality inserts made of the best extruded rubber or synthetic components. Modern high quality inserts are amazing for comfort.
Finally, buy a few pairs of high quality wool socks--usually they will contain 70% Marino wool content. These, too, can be very expensive if you want good ones, but they wick moisture way better than any cotton sock and last 5 times as long. They are available in just about any thickness you choose. And of course dedicate a couple pairs to just pool playing.
Be forewarned--once you invest in quality wool socks you may never be able to go back to wearing cotton socks again.