joomla - List of users who registered in the same month as the logged user -

i need create custom module shows list of users registered in same month logged user.

you have start learning how create joomla module.

then familiar joomla database functions.

once create module, have active user using current user object.

next step run query #__user_profiles table active user register date. query like:

select `registerdate` `#__user_profiles` `username` = $user_id 

and run second query users registered same month active user:

select `username` `#__user_profiles` month(registerdate) = month($current_user_register_date) 

good luck!