I’m using PDO syntax, not mysqli, so it may be a bit different to what you are used to.
It’s not tested, more thinking out loud the sort of thing that may work.
Getting the data and displaying the data are two separate things, so they will be kept separate.
My example was only concerned with getting the data.
Outputting it would be handled elsewhere, but may use a foreach to go through the array that was made.