Join problem with two fields named the same

Write the query yourself, it's reasons like this I never use CI's ActiveRecord methods.

Code:

$sql = "
    SELECT
        p.*,
        b.id AS brands_id, b.image_path AS brands_image_path
    FROM
        products p
        INNER JOIN brands b on p.brand_id = b.id
    WHERE
        p.brand_id = ?
";

$results = $this->db->query( $sql, array( $id ) )->results_array( );