COUNT() and link between tables
SELECT
    A.id build_owner,
    COUNT(C.build) build_member_count
FROM member A
INNER JOIN build B ON A.id = B.member       -- or LEFT joins
INNER JOIN up    C ON B.id = C.build        -- 
GROUP BY A.id ;