mysql查询一张表字段在另一张表中出现的次数

SELECT
    *
FROM
    (
        SELECT
            t1.projectCustomerPhone phone,
            count(t2.phone) count
        FROM
            (
                SELECT
                    *
                FROM
                    t_projectcustomers
                WHERE
                    projectId = 'ac500158ccd148e9a9e9fd3c42f5d76a'
            ) t1
        LEFT JOIN (
            SELECT
                *
            FROM
                t_visitrecords
            WHERE
                writeState = 1
        ) t2 ON t1.projectCustomerPhone = t2.phone
        GROUP BY
            t1.projectCustomerPhone
    ) AS cc
WHERE
    cc.count >= 2