As I've always understood it: it's a unit test when you are testing a single unit ( / class).
You are only testing the Team object, so imo, it's a unit test.
You are saying 'it hits the database' so what? It doesnt have to as you are only testing that, when you add a user to a team, it is in the team. The test doesnt check the database for that, it asks the team object (which could for instance just be writing ID's to some text file)
As long as you only interact with the Team object from within your test, I believe this to be a unit test.
As soon as you try to hit the website, filling in a form, and then testing if a team has a certain user in it, or if you use the Team object to add a user, and then you check the DB if it has the right data in it, at that point you are actually testing if Team can work together with Database (or Frontend) which would make it a feature test.