The basic idea is:
Create a recordset that searches the pcms2_users and filters by the entered first and lat name.
create a repeat region to display the information from the pcms2_users recordset.
create another recordset to search the related tables, set it to filter the UserID relational Column on a URL Variables named UserID
this recordset will be moved inside the repeat region for the pcms2_users recordset, and you will add code to set the UserID URL variable to be equal to the UserID column from the pcms2_users recordset
there is not much of a difference in creating this using MySQLi or MySQL