SELECT u.`id`,
                              u.`name`,
                              u.`gender`,
                              u.`reg`,
                              u.`sign`,
                              u.`posts`,
                              u.`sign_active`,
                              u.`avatar`,
                              u.`avatar_size`,
                              u.`group_id`
                       FROM `pmf2user` AS u
                       WHERE u.`id` IN ()

SELECT var.`name`, val.`value`, val.`user_id`
                       FROM `pmf2user_field_value` AS val,
                            `pmf2user_field` AS var
                       WHERE val.`user_id` IN ()
                         AND val.`field_id` = var.`id`