How can I output a legible timestamp from "1583981745.335346" (stored in a 'double' field type) via a select statement?
FROM_UNIXTIME can help.

select from_unixtime(1583981745.335346)

2020-03-12 02:55:45.335346


ref: fiddle

This is a datetime type so it can be handled as such in PHP.