count_all with joint two table

On your result, you have a method for counting : $query->num_rows();