php - mysql select rows with top max value -

i have table in mysql columns: id , view , agree. have upload table's image below:

i want select 8 rows greater others in view column. condition agree = 1.

can tell me how can mysql query or php.

select * table_name agree = 1 order view desc limit 8