So, I'm thinking about building a database for family trees. There's a table for people, and there's a table linking people to other people, by spouse or parent relationships.
Later, if I want to pull all the people related to a specific individual, how would I do that efficiently with mysql?