$userid = "1"; $getinfo=$DB_site->query_first("SELECT userfield.*, user.* FROM user LEFT JOIN userfield ON (user.userid = userfield.userid) WHERE user.userid = '".$userid."'");