query Parent and child table values at a time

[ghost]

Dialect

MySQL

Failing SQL

SELECT *,
(SELECT COUNT(tableb.tableA_id) FROM TableB WHERE TableB.tableA_id = tablea.id) AS count
FROM TableA tablea;

Description

I have a Parent table and child table with foreign key association. i need to query parent table along with count of each id in child table.