join same table twice and get the results of rows
How about a "self join":

SELECT a.object_id
    FROM wp_term_relationships AS a
    JOIN wp_term_relationships AS b  ON a.object_id = b.object_id
    WHERE a.term_taxonomy_id = 44
      AND b.term_taxonomy_id =  8;