/* table 1*/

id	name
1	randomrowname1
2	randrname2

/* table 2 */

id	id_table1	name
1	1		rand1
2	1		daess
3	1		sdadasd
4	2		dasda
5	2		asdas

/* result table */
table1.name		table2.id_table1	table2.count
randomrowname1		1			3
randrname2		2			2