How to get data from the database table by MySQL query in Magento?

protected $_resource;

public function __construct(
    \Magento\Framework\App\ResourceConnection $resource
) {
    $this->_resource = $resource;
}

public function execute()
{
    // get connection
    $connection     = $this->_resource->getConnection();
    // table name
    $tableName = $this->_resource->getTableName('your table name');
    // Query
    $select_sql = "Select * FROM " . $tableName;
    // fetch result
    $results = $connection->fetchAll($select_sql);
    // print result
    print_r($results);
}