How do I get a list of all users with role = ‘Customers’ including all the metadata per user, means wp_users + wp_usermeta.

Query below does not generate the wanted results.

    $query = "SELECT * FROM wp_users INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id ORDER BY ID DESC');  ";

    $data = $wpdb->get_results($query,ARRAY_A);

But that list is not correct. It shows each user x times depend of the amount of rows in wp_usermeta.

How can i filter it? That each user shows per record all his user + metadata?

Still searching for 6 hours.