how to delete all data relating to the data to be deleted?

@meglo in your migration if you have set up foreign key constraints

$table->foreign('user_id')
->references('id')->on('users')
->onDelete('cascade');

to cascade on delete then this should also update your join table to remove records.

see

https://laravel.com/docs/8.x/migrations#foreign-key-constraints

i'm not quite sure of your error though:

All records for employee id 1 in attendance_employees are also deleted. because when I delete the employee id 1, but the employee id 1 data is still in the attendance_employees table, an error will occur. how to handle it?

as you say all records are being deleted for employee but also they aren't ??

this is the error: if i dont delete data from the pivot table, where the data are related. but if i delete data first from the pivot table, no error occur. i think i will try your suggestion. i will hit best answer if this work. thank you information about cascade.

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (pt_demo.absensi_karyawan, CONSTRAINT detailabsens_karyawans_id_foreign FOREIGN KEY (karyawan_id) REFERENCES karyawan (id)) (SQL: delete from karyawan where id = 2)

@meglo can you post the migrations for your tables so I can install locally and see?

thank you i already use your sugesttion. its work.