How to display user_nicename and usermeta values by custom query in WordPress?

To do that with WordPress functions, you can try that

$users = get_users();


?>

    <table>

        <tr>
            <th>Customer Name</th>
            <th>Customer Details</th>
        </tr>

        <?php foreach ($users as $u) {?>

            <tr>
                <td>
                    <?php echo htmlspecialchars($u->display_name);?>
                </td>
                <td>
                    <?php echo htmlspecialchars($u->description); // retrieve the meta "description"?>
                </td>
            </tr>

        <?php }?>

    </table>

<?php