How Do I Fetch And Display Data From Database In Wordpress?

Data Tables Generator has a database source option that gives you the ability to display the table or even its individual fields from the database on the front-end.
This means you can display data from any table, whether out of the WP Database or an external database. You may also make Database Query the source. The plugin works on any engine supported by WordPress.