To learn kol-in records in the connected table?

Question

MySQL

There are two tables
Table_1
id | title
------------
1 | One
2 | Two
3 | Three
Table_2
table_1_id | user_id
------------------------
1 | 1
1 | 2
2 | 1
When selecting from the first table, I want to see
id | title | count
-----------------
1 | One | 2
2 | Two | 1
3 | Three | 0
How to make a query to get the specified result?

Answer 1

select table1.title, count(table2.id) as count
from table1 
left join table2 on table1.id = table2.user_id
group by table1.id

More or less like this