Since version 4.0 of BuddyPress Members Import no more need to create Groups manually.
In CSV file you have to declare user group(s) name (separated by :: if more than 1) under column `member_groups_name`
So now let say in system you already have 2 groups of id 2 and 6
You want to import a user and want to map that user with 4 groups 2 existing and 2 new. New groups name are Artist and Designer.
Then in CSV file under column `member_group_ids` values should be “2::6” and under column `member_groups_name` values should be “Artist::Designer”
Please provide your queries in comment section 🙂