SELECT m.mail, m.member_id, fn.value AS first_name, ln.value AS last_name
FROM members m
LEFT JOIN userdata fn ON fn.member_id = m.member_id AND fn.key = first_name
LEFT JOIN userdata ln ON ln.member_id = m.member_id AND ln.key = last_name
Userdata = name of the table containing user data...