query to know simple product is which is not associated to configurable products into magento 2

Please do find below query.

SELECT `e`.*, `link_table`.`product_id` FROM `catalog_product_entity` AS `e` LEFT JOIN `catalog_product_super_link` AS `link_table` ON link_table.product_id = e.entity_id WHERE (`e`.`type_id` = 'simple') AND (link_table.product_id IS NULL)