WordPress Selecting multiple rows


Example

You can use get_results to get multiple rows from database.

global $wpdb;
$userTable =$wpdb->prefix."users";

$selectUser = $wpdb->get_results("SELECT * FROM $userTable"); 

This will show all users list in array.