mysql 多表数据求和,MySQL-多个联接表的求和计数

I will do my best to explain this clearly. I am trying to accomplish two things, but am having trouble even getting the first to work correctly.

I have a schema that has a member table which has foreign keys to multiple tables. In the end I am going to be drawing from about 10 tables that may or may not have records for a particular member. I am trying to get the sum of all the counts. My query looks like this:

SELECT (COUNT(tb1.member_id) + COUNT(tb2.member_id)) as total

FROM members m

LEFT JOIN table_1 tb1 ON tb1.member_id = m.member_id

LEFT JOIN table_2 tb2 ON tb2.member_id = m.member_id

WHERE m.member_id = 27

Where 27 is the member_id of the test account I am working with. This doesn't produce accurate results and I believe it is because of the left join, it seems to be throwing things off and I am getting a total of 8 e