Mysql query - Count the founded rows on joined table : <p>I have two tables</p>

<p>First one: Offers</p>

<p>id
user_id
user_data</p>

<p>The second one: Orders</p>

<p>id
user_id</p>

<h2>order_data</h2>

<p>Now, the goal is, to get the list of the OFFERS including the count of the orders table, where orders.user_id == offers.user_id</p>

<p>the result must be:</p>

<p>id
user_id
orders_count</p>

<hr>

<p>Thank you in advance!</p>
