You can install a plugin called configurable reports in Moodle. Here is the link => https://moodle.org/plugins/block_configurable_reports.
Then you can write a query to get the registered user data.
Select * from mdl_user; // To get all users
Select * from mdl_user where auth = email; // To get all users who have registered themselves and not created by your lms admin.
Then you can write a query to get the registered user data.
Select * from mdl_user; // To get all users
Select * from mdl_user where auth = email; // To get all users who have registered themselves and not created by your lms admin.