Here is a statement for the question:

SELECT t1.customer_id, COUNT(t2.customer_id) AS occurrences FROM table1 t1 LEFT JOIN table2 t2 ON t1.customer_id = t2.customer_id GROUP BY t1.customer_id;