$uid #contains usersid
($uname, $upass, $uemail) = $dbi->fetchrow_result("select User_ID, Name, Password, Email from User_Table where User_ID = '$uid'");
#output basic info

$sth = $dbi->prepare("select MailListName from Mailinglist_table, Subscription_table where Subscription_table.MaillistID = MaillingList_table.MaillistID  AND Subscription_table.User_ID = '$uid')
$sth->execute;
while (($subname) = $sth->fetch_row_array) {
    #OUtput MaiList Name
}