I set up a MySQL database on my web server and then created 3 PHP script endpoints to query the database and return the information in JSON format. This was then read by an HTTPget request from within unity and strings printed into their associated container locations.
Pretty simple really.
If you have a look in my repo Raining-Cats-and-Dogs/Assets/PHP files for Leaderboard at main · Skuzzle-UK/Raining-Cats-and-Dogs (github.com) this is a direct link to the php files and the leaderboard scripts and scene are in here Raining-Cats-and-Dogs/Assets/Scenes/Leaderboard at main · Skuzzle-UK/Raining-Cats-and-Dogs (github.com).