sql – How do I be a part of publish and postmeta twice?

I am attempting to affix the next tables

postmeta

posts

Presently, I am utilizing the next question

SELECT post_id, meta_key, meta_value, post_title
FROM postmeta
INNER JOIN posts ON meta_value = ID AND meta_key = '_team_id' 
GROUP BY posts.post_author

I get the next:

How do I add the second meta_value, utilizing the earlier meta_value because the id? In order that I get the next…

Any assist can be very grateful.